Rather than using copy/paste special, is it possible to simply transpose a
whole worksheet?
Thanks,
Clem.

in excel 2000 sp3, i found a bug using conditional formatting.
Let's say i have two cells A1 and A2.
I want to set A2 backcolor according to A1 backcolor.
If i set conditional formatting on A2 cell, using =iscouleur("A1")

Happy new year ! Maybe someone can help me!
I want to know if anyone knows how to activate th
autosum/average/count function in excel which is displayed in the righ
bottom corner of the screen if you selct more then one cell with

I just installed Office2003 in conjunction with WinXP Pro SP2.
When Excel file (xls) is opened, "File" menu is missing.
Please advise me how to recover File menu.
Craig

how can i format cell containing WI12345 to be displayd asWI 12345 (
with space after 2 signs )
thanks
mcg

I want to convert my data from one column into rows.
I have my data set up now as follows:
John Smith
$3200

I was wondering is anyone can tell me to how to have a fixed heade
row.
By that I mean, I have a pretty long spreadsheet. I want the first ro
(row 1) that has my headers in it to remain fixed when I go down th

I have a spreadsheet of data, lets say 35,000 rows long.  So when I do
a [Ctrl] + [End], it goes to the cell at row 35,000 (and the last
column of the data).
Now lets say that I run a macro that deletes 5,000 rows.  So now the

Is there anyway to put the currently active worksheet's name in a cell?
Not the filename of the whole workbook, just the currently selected
worksheet.
Thanks for your help.

I have worksheet protection setup on a excel worksheet.
I want to know if there is a way to prevent users from highlighting the page
and creating their own worksheet so they can make changes.
As of right now, the worksheet prevents any changes but people have been

Can anyone help me?

I've been asked to prepare a workbook show data tables to generate a
xmas tree graph. Does any know how to do this in excel?

I have a file that sorts data from one worksheet onto another.  It
refers to that worksheet by Activesheet.Next.Select and it worked fine.
If I try to hide that worksheet, it fails.  How can I refer to a
hidden worksheet so this Macro will work as it does if it is not

In my workbook, I have varying numbers of worksheets, each with
numerical values in the A3 field.  I then have a sheet which totals up
all the A3 values of each worksheet.  My problem is that the number of
worksheets varies, and when I add/remove worksheets from a workbook, I

Hello I am new and exhausted from trying to find an answer to m
problem.
I enter a date into a cell (ex. 020206 which should auto format t
02/02/2006) but when I hit enter I get a weird date that comes u