Mac Forum / Applications / Excel / February 2006

I've been trying to figure out how to do something.  I keep a very simple
spreadsheet of my installed downloads, with a column detailing the memory
used by each download, and a SUM function totalling these data.  When I
delete the intsalled app I simply change the font to red & ...

can someone tell me if there is an alternative to viewing multiple
worksheet tabs in an excel workbook. with multiple sheet tabs only
displayed at the bottom of the workbook, it is difficult to move easily
between sheets. is there an option to view sheets in a "menu" style or

Is there an easy way to copy a row or column and paste only the non-blank cells?
I tried transpose checking the "skip blanks" box to no avail.
thanks

I have excel in my mac laptop and i transferred files and apps to my
new mac mini. But when I use Excel in the mini, it keeps giving me this
test drive pop up. What do I do? I didn't save my box or registration
number from the copy of Excel I bought. Secondly, this test drive does

I am using Excel X for Mac on a G3 system 10.
I have placed 900 controls on a Userform.
No, they do not all display at once; display depends on which pages of
several Multipage controls are selected.

An example: To delete a column on Windows, I use the keyboard shortcut
Cntrl+EDC (meaning, hold Control, type E for EDIT menu, then D for DELETE,
then C for COLUMN).
  I would like to set Excel for Macintosh (using OS-X (10.4.4) to enable

Looking for help w/ the formula bar in excel.  When I move into a cell
nothing shows in the formula bar.  However, if I enter a number the
rest of the formula will appear.  Is there anyway to change the formula
bar to show what is existing in the cell?  Thanks.

On an almost-brand-new last-ever G-4 PowerBook, running Tiger (10.4.4),
with a clean-installed (not upgraded) copy of Microsoft Office 2004,
Excel is just about unusable.  Every time Excel (and no other software,
including no other component of Office) opens, it attempts to open

I have a useform created in Excel 2003 with a commandbutton that has a
picture. When loading the file under Excel 2004, the userform appears as
being empty. If I remove the picture from the commandbutton, the userform
loads fine.

I'm just wondering if & how it is possible to freeze panes in TWO locations.
I have a very simple (but long) table in the following (simplified) form:
Title       Title       Title
---------------------------------

[Sorry about the mis-post earlier]
Hi,
I'm just wondering if & HOW it is possible to freeze panes in TWO locations.
I have a very simple (but long) table in the following (simplified) form:

   After a vlookup etc, isn't there a way of simply changing unmatched
or #N/A to 0 so the addition formulas are still good.  this would be a
great tool to have.  thanks.

Is there a SIMPLE way to distiguish numbers resulting from a calculated
formula from numbers just entered from the keyboard?
In a worksheet, the values in a column are calculated by formulas.
I now want to overrule some of the values (integers) by entering a

I had office 2004 installled on my imac at work and the pdf toolbars
load every time.  I've tried close them and restarting but they return.
I tried trashing the excel toolbar and the plist preference and they
return.    I am having the same issue in word and would like to get

i am trying to enter account numbers for credit cards-traditionally 16
digit numbers. Excel drops the 16th digit and changes it to a 0. I have
tried cutom formatting the cell to 17 digit numbers (and every other
formatting trick I can think of) and it will then show 00 at the end. I