I am making a spreadsheet with interest calulations for each month. Some
calculations can go as far back as 2004. I would like to know if there is a
formula or a way to format the cells so that each date can automatically the
end of the next month. For example, in cell A6 it ...

I am relatively new to excel and know what I want to do but little idea on
how to do it.
Background
The data is for our transport company who is carting numerous material types

I would like an Excel file to ask the user whether they would like to open a
file as read only when they open the file.  How do I go about doing this?  
Thanks!

I know you can right click on the tab scrolling buttons to get a (short) list
of all worksheets and the option 'More sheets...' opens a window called
"Activate". is there a keyboard shortcut or a macro to invoke that "Activate"
window?

I am having difficulty pulling background and font colors from one workbook
to a linked workbook... I have individual "weekly schedule" sheets for each
employee, and link them to a master timesheet which pulls only certain
information over to be used in scheduling meetings.... ...

I have a column of thext in Excel that is
111222333
or
111222333L

Hi there...
Excel is leaving a xxxx.tmp file on the server where i keep the excel docs -
Should they not disappear automaticly? Every time a document has been opened
- it leaves a file with the same name except for the .tmp extension.

I need a formula to look for a range of cells and display the max number
among them along with the data adjacent to the cell in a different cell.
Let me explain in this way..
A1             B1

Im trying to record a macro which at the end of running prompts the user to
do a "save as", when I'm recording it and select the save as option it brings
up the box to input you file name & save location. Its at this point I want
the macro to stop and the user can then put a new ...

Is there a way to use a macro in a workbook to move a file from one folder to
another folder by copying it?  I tried to record a macro to do it but nothing
shows up in the VB editor.
Thanks

I have a workbook with multiple sheets.  In the sheets I have cells filled
with various colors indicating where information is input by me or where it
is automaticaly input.  This is done with varying types of conditional
formatting. When I print I would like to print with no ...

I have a number of very large spreadsheets all with percentages. I want to
change the cells from % to whole numbers. I did this the other day and it was
obviously something very simple (for me it has to be simple) but for some
reason I have gone completely brain dead and can't ...

How do you opening a workbook when you click on the Excel desktop icon. (Very
fustrating not remembering these things. :( )

I have a large spreadsheet in which I wish to display fractional values up to
16ths.  I want the fractions to round down to the lowest denominator.  For
instance 8/16 should display as 1/2 and 10/16 should display as 5/8.  The
spreadsheet is too large to go through and ...

I followed all the various instructions in the help file about adding tabs,
but it seems only to work when you open a new workbook. My problem is how do
I add tabs to my current workbook that has only the default three tabs.