Mac Forum / Applications / Excel / January 2006

I have a list of column headings but they are all in one column, is it
possible to copy the column and paste it into a row?
Eg.
A

I cannot create a formula for a simple function related problem. If A1
equals the number of calls a fire department gets in a month (200), and
B1 is the number of calls a single fireman responds to (60), and C1 is
the percentage of calls the fireman in B1 responds to, BUT it cannot

Is there a way to change the colours of the worksheet tabs in a workbook?
It would be handy when looking through all the chart types or similar sheet
properties, to see the similar types of worksheets.  Thanks   John
Ps;  I think Quattro pro does allow this formatting of the ...

Gang,
I have a few spreadsheets in which I use List Manager extensively.
Lately, I have had enormous problems with formatting, when
copying/pasting, and when adding new rows.  It simply refuses to use

Is there a function, or a short cut, in Excel for calculating the
annual increase needed in an investment to get from initial value A to
closing value B in a given number of years? I can work this out by
giving each year a row in a speadsheet and fiddling with the data so

Excel 2004 (version 11.2) has just started doing something very bizarre
and very counterproductive.  Whenever I copy some cells and then
deselect them (or paste some cells that I've cut), the workbook window
I'm in DISAPPEARS!  It doesn't close, it doesn't get minimized, it just

I have no idea how this happened, but when I enter text into cells
under a particular column, Excel automatically fills the background
yellow.  Can anyone tell me how I can put a stop to this?

Hello, helpful people!
I have a reporting dashboard built in Excel that has eight mini-charts
on an overview sheet, arranged in two rows of four. The columns
containing the charts are 30 units wide; the rows are 175 units high.

Can anyone tell me how to turn off AND leave off the PDFMaker Toolbar.  
I'm running Excel 2004 on Tiger.  I tried the obvious solutions, even
deleting it from Preferences folder and also tried moving Adobe to the
trash - both without any luck.  This is driving me crazy.  TIA

Does anyone know a keyboard shortcut for switching between sheets in a
workbook? I simply LOATHE having to grab the mouse to switch to another
sheet!
Thanks!

I'm using the wrong term, I know it. I have a simple formula where I am
subtracting an amount from today from a value on 12/31/05. I want to
then copy the formula to the adjoining column without having the value
of 12/31 change. It has something to do with $ signs but it's been

Is there a way to add a column that contains some  #DIV/0! values and ignore
those cells in the calculation?  Or do I have to provide for the DIV in the
individual cells with an IF statement of some kind?
Thanks

I am using Excel to chart some company bids.  I look at a list of
monthly projects and when I find out that we won a bid I fill the
background of the row green.  If we lose I fill it red, and if it's up
in the air I fill it yellow.

I have no idea how this happened, but when I enter text into cells
under a particular column, Excel automatically fills the background
yellow.  Can anyone tell me how I can put a stop to this?

I received and Excel spreadsheet from a Windows user and in it the column
headings at the top remained visible as I scrolled through it.
How does one set documents to do this in the Mac version. I haven't been
able to find a command or setting.