Mac Forum / Applications / Excel / June 2005

Since I had such positive responses to my last question, I have another
one. One column in the large file is for 'years'. But I don't want them
as numbers because some years have letters with them and when I sort
the column I want these sorted in with the other years. The column

Can anyone tell me how to put symbols into the axis captions on Excel
charts in Mac v.X? On a PC, I can draw a text box, then pull down the
"Insert" menu and access the symbols there. This option does not seem
to be available in v.X. I need to insert various lower-case Greek

Okay, so one of the big benefits of using Excel is that you can trust
the math operations, right? Well, believe it or not I am having a
problem with s simple SUM function. This is a little convoluted but I
appreciate you bearing with me while I weave my tale of woe:

I have downloaded data in Excel format from a PC server onto my Mac OS
X 10.3.9.  I have Excel 2001.  The data in the formula bar of every
cell starts with an apostrophe ( ' ) before the text or numerals.  I'm
trying to sort but the sort function seems to think the apostrophe is

Is there a way of making a series of pie charts exactly the same size not
only in the chart area but also making the pie itself the same size and in
the same position within the chart area?
If so, how can I do this? The setting will have to be done after the pies

I would like to use the progress bar in the status bar, in the same way
Excel is doing when saving the document:
- left side contains some text
- right side is a progress bar

I'm using Mac Excel 2004 fully updated.
I've constructed a list of 50+ names, addresses, etc., and have
successfully copied data from my web browser to a cell. I was not using
the List Manager. I saved and closed the file. When I re-opened it and

I get this   error  message  and  don't  understand  where  to  look.
if you have just installed a new version of Mac OS X and you used the
Archive & Install option, the preferences files have been archived to
the Previous Systems folder on your hard disk. To restore these files,

Whenever I open spreadsheets, the top part is often hidden under the various
toolbars.  The only way to get to the top part of the sheet is to grab the
toolbars and pull them out of the way. I do this enough with the clutter on
my real desk and really don't need such idiocy on my ...

I can't figure this out:
I have a small workbook with three sheets: Sheet 1 previews and prints fine,
either Portrait or Landscape. Sheet 3 is blank.
Sheet 2 won't print anything at all. It has 8 columns and 55 rows filled and

I am still unable to sort my Excel file of 8855 rows because I get a
message saying I have merged cells. I followed the advice of previous
group members and went to the format menu to see if I had inadvertently
checked the 'merge cell box'. I hadn't. This is very frustrating. I can

I went from Tiger back to Panther on my G4-500. Because Panther wouldn't
install.
Anyway I opened Excel after all the getting everything back to normal
and a message came up on every font family I had in my collection was

The mysterious mystery of the phantom printing error!
Synopsis:
Recently upgraded to new G4 mac minis running Mac OS 10.3.9, and MS
Office for Mac 2004 educational edition. (Updated to version 11.1.1)

I've just started a new job, and of course they are a PC office and I'm
a Mac guy.
Work requires the use of a spreadsheet (attached as binary) which has
macro's in it. But the macro's are not working on my Mac.

I have created an excel document under windows xp/office 2003, this
document contains ~20 worksheets, and some vba code behind.
Using this excel file on windows works fine.
On a macintosh, I cannot save the document ("Document not saved")