I have a document in which I have to do my report in thousands i.e. $1000
represents $1,000,000. How do I divide each data cell by 1000 without
individually dividing each cell by 1000?

sometimes my xl files convert to xlxs why ? how can i fix this ?

I have a range of data from B2:H88 which contains formulas also.  I want to
devide the cell values in the range with 41.  Is there any way to edit the
all cells in the range in one go to devide it with 41 other than individually
edit each cell.  If it can be done with a macro ...

I am unable to open one of my Excel file. It is not responding.
Please help me to recover my file.
Thanks & Regards,

Will the scroll (Horiz, Vert) bars generate an event that can be
handled with a user defined macro? I have problems with freeze panes
on using the horiz scroll bar. A dropdown list on the freeze pane is
displaced from its original location on paging to the right using the

I have conditional formats in cells in worksheet A. When I refer to those
cells from WorksheetB, I want to reflect the formats they have in Worksheet
A, in WorksheetB
Any thoughts

In previous versions of Excel it has been possible to edit the image which
appears on a button in the toolbar.  I used it when I assigned macros to
buttons.  In Excel 2007 I have found that only the Quick Access Toolbar is
(readily) customisable but the choice of images is poor ...

I have an excel sheet, a pretty huge one, that queries ANALYSIS CUBES
(database) to get the data onto its sheet. I have a sheet where a
particular set of columns are frozen in the left. Since the sheet
which is a report has data for months, I'll have to scroll to the

Does anyone have any suggestion on how to count the matched values?
There is a list of values under column A & B
[Column A] 1,5,6,8,9,10,3,20
[Column B] 6,4,9

I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.
Jai

I have more than 100 worksheet in a workbook among which I have to continuous
use 4-5 worksheet. Can I add  buttons with the names of these worksheet in a
worksheet. So that by just clicking in a particular sheet name button I can
directly reach into that sheet.

How do I get a drop down list arrow to remain visible at the top of a column?
I've seen it before but am not able to figure this one out.  I'm using Excel
2003.  Thank you!

Sometimes the formatting of the documents I print is different than what my
Print Preview shows.  Why?  How do I fix it?

i have a list of dates that i want to pull into one roll if  
example:  IF dates between 7-1-07 and 7/8/07 than choose 7/8/07

Does anyone have any suggestion on how to count the matched values?
There is a list of values under column A & B
[Column A] 1,5,6,8,9,10,3,20
[Column B] 6,4,9