Mac Forum / Applications / Excel / January 2007

The annoying feature that make e mails and weblinks live, what is fastest
way to clear them from a full excel worksheet, and then get rid of that
future permanently. Thanks!
Kevs

Anyone know of a Utility (or whatever) that will allow Excel 2004 for Mac to
show colored page tabs? The colored tabs displayed on my spreadsheet created
with the Windoze version just doesn't show up on the Mac version of Excel.
Thanks!

Okay - what I am trying to do is make a large spread sheet look pretty.
The spreadsheet is tracking the number of surgeries for 3 docs over
time.  If a value of one of the surgeries is 0 (eg no surgeries of this
type done) I don't want the cell to display anything.  (This keeps the

It seems that Excel 2007 does not produce pivottables from multiple
consolidation ranges as in past versions.  I find them extremely useful in
combining budgetary data.  Have I missed something?
Any assistance on this issue would be appreciated.

When selecting multiple worksheets from a workbook, the print|Save as PDF
function sends a print job for each worksheet, numbers the pages correctly,
but the PDF generated only includes the last worksheet's pages.
So, it looks like the worksheets are not being concatenated into a ...

anyone know how to use replace to change the pattern (eg color) of
multiple cell having the same contents? E.g if a cell reads "tree" in
black and white, can you replace it with "tree" in a green cell
backround? This is easy to do on excel for windows because the replace

I'm new to using the MAC Excel version.  I want to highlight a portion of a
formula and press F9 to have Excel evaluate it.  This works on all PC
versions of Excel.  Also, in the MAC Help it says pressing F9 calculates all
sheets in all open workbooks.  When I press F9 the ...

How can I keep autofilter working in protected sheets in Excel 2004 for
Macintosch?
Thanks from Munich
Wolfram Fuchs

I have a document that has been sent to me that Office 2004 won't open,
but Excel XP will. When I open it, a progress dialogue starts saying
"Converting Meta file" and then another window opens and says "unable
to read file".

Can someone help as I can't open excel 2004 anymore.
My system froze with excel and a load of other applications open.  I had to
do a hard restart (power button) to get it going again.
I tried to open excel, and when it is opening and trying to recover

I have two columns with numeric values A & B, and i want to calculate in to
a C column,  for each row, how many rows in the table meet that their A value
is between ( (ActualRow A value-1) and (ActualRow A value+1) ) and B value
between ((ActualRow B value-1) and (ActualRow B ...

For reasons I cannot figure out, the "num lock" feature on my G4 ibook
is locked in to only work as arrows.  That is, when I press the number
6 I move right one cell, and when I press 4 I move left one cell.  This
is only happening in Excel.  I have become addicted to inputing data

I have noted that it could be possible use some WinExcel command
shorcuts (without any special configuration) in MacExcel 2004, for
example CTRL+D to copy value that's above the active cell. I would like
to know the whole list of commands using this windows method.

Am trying to get my little macro to search for a particular month in a
particular year and match it with a criteria before providing a total.
For example, am searching under column A for "Jun=06" then matching it
with "S/W" before summing up with the total figure.

I am trying to use CRTL-L to DEFINE names.  Have used it many times in the
past.  This key combo does not seem to work anymore.  I checked the
TOOLS>CUSTOMIZE>COMMANDS, and that combo is set for DEFINE.
When I hit CTRL-L, nothing happens.