I use pivot tables a lot and use auto formatting to get the basic shell for
my tables. (I prefer "report 4". After applying this format I do some manual
clean up like changing decimals to % and centering data in the columns and
rows.

I can't believe my patterns have been removed from Excel and Powerpoint.  I
commonly use cross-hatching in combination with colours to ensure my
presentations are printable and photocopyable; and in the case of excel I use
cross-hatching of spreadsheets that display attendance ...

I need some shlp please, I have 4 check boxes on the same line and would like
to be able to check one and if I change the check that it automatically
uncheckes the one that is already checked and checks the new one.  In other
words if i have already checked the first box, and ...

I would like to see a printout of my comments using the contents of the cells
I'm printing, not "Cell: c8" for example, but "Cell: 478232".

I have a cell in whic the formula may return a positive time or negative time
depending on the hours worked.
I can format the cell to display a positive time or a negative time but not
to switch between the 2.

I am using the Event Schedule Planner from the Excel office file. It is dated
2006 and I need to get the 2007 version. When will it be available?

I have a range of data and need to sort four colums but when I use the sort
key it only allows me to sort 3 types.  For instance I need to sort company
name, product name, date ordered, and origin of product.  (those are my four
colums) and the sort function only allows me to use ...

I have some spreadsheets that will automatically copy the formula above when
data is entered in the cell to the left of the cell where the formula is
needed. I can't find how this feature is turned on.......

I want to change the background color of cells where the cell date is less
than or equal to the current date.  How do I put in the current date in the
formula?

I am pulling data from analysis services into a piviot table.  Is there a way
withing the pivot table to add a calculation please?

When pressing the down cursor key many times to go down a column row by row
in Excel periodically spell check will launch and move the cursor to a
misspelled field.  Has anyone else experienced this?  If so, is this a
"feature" that can be turned off?  If so, how so?  I am a user ...

I have a spreadsheet that will have up to 20,000 lines on it.
A1:K20000.   Cell I2 is the cell that I use for the line color.
It will have 4 possible options.  'I', "H", "O", "C".
(Would like to use a drop down list if that would work with the line

I have a spreadsheet in which I need to lock two columns so they cannot be
changed.  I don't need to lock or protect the entire spreadsheet as others
have to be able to use the dropdown arrows for filtering.
How do I do this?

I am having difficulty combining dynamic ranges together with the
indirect function in data validation. I have a number of dynamic ranges
that are created using the offset formula. I then have a worksheet with
data validation. The data validation limits the choices a user can

When using data in MS Excel, I frequently have a column with length 9 string
of all digits. If I want to export to Access or save as a *.csv, Excel
converts this to scientific notation and it cannot be converted back to the
original data.