Mac Forum / Applications / Excel / January 2008

I downloaded a free cashflow template and wanted to add more rows to it. I
went to 'Insert' in the toolbar menu, but 'row' was greyed out, along with
'cells' & 'columns'.
Any advice appreciated. Thanks.

Am using a G4-400 with OXS 10.4.11 Gig of ram. Office MAC 2004, (Excel
version 11.3.5)
1.    Even though I have repeatedly checked the " Provide Feedback with
Sound" box in General Preferences, often I get no sound when saving a

I'm writing a macro that will identify the plant's ID by looking at a cell
(A9).  
My if statement has an error and I can't figure out what is wrong with it.  
The error is somewhere here and it says I have a "compile error: syntax

I have a column of percentages with lots of places beyond the decimal point.  I
want to count the number of occurrences of a single percentage, say 5%.
If I could round up all the values to only 2 decimal places (.05 for example)
it would be easy enough.

I'm having trouble opening Excel files created on my own computer. My
new Intel iMac has Office 2004 running under Os 10.5.1 and Office 2007
running in Boot Camp under WinXP sp2. In Windows, I saved a very basic
Excel spreadsheet and then booted into MacOs and dragged the file ...

Is there a way to print a worksheet by every change in record.  For example:
in column "A" are all customer names (all other columns relate to that
customer info)  Is there a way to print a new page after Excel recognizes a
change in every "record" or customer name.  This would ...

When I try to convert an Excel file to a PDF by selecting
File>Print>Save as PDF I get nothing but blank pages.
In addition, when I try print preview I get blank pages as well.
I've made sure to set print quality to high, as recommended.

I am not sure why it doesn't do it now (Excel must have decided on
it's own to turn it off!!!!).
If I have a formula existing in a cell, I move to the cell and press
F2, the formula cell references should show in color with the

I've posted this awhile back but can't get a simple answer to this.
I have a document with 1200 rows.
Below that is 9000 more blank rows.
Hence 90% of the workbook is nuisance rows.

I've just upgraded to Leopard.  Now when I open a NEW document Excel it
defaults to 4 columns x 20 rows.  No preference I change or page layout I
play with will let me alter it.  I also just ran a software update to be sure
it wasn't something that could solve.  Anyone have any ...

are there any downloads available that will make spreadsheets I work on with
my laptop that has vista - compatible with my desktop that has XP?

For some reason whenever I try to use numbers in a cell, instead of
(example)
11.28
it keeps adding a comma, making it

I wish to format a column so that the numbers:  
1236785555 will appear (123) 678-5555.
I have tried several different things suggested in "Help" but nothing seems
to work.

I hope someone can help me with this formula. I am trying to count the
number of times one column with a certain phrase in it has a date
entered in another column. We have been using a variation of
=SUMPRODUCT(--($D6:$D1242=D1250),--(G6:G1242=G1246))

I hope someone can help me with this formula. I am trying to count the
number of times one column with a certain phrase in it has a date
entered in another column. We have been using a variation of
=SUMPRODUCT(--($D6:$D1242=D1250),--(G6:G1242=G1246))