Mac Forum / Applications / Excel / June 2006

i'm new at this, so please be gentle
i am running office for mac 2004 pro on a powerbook g4 1.5g with 512k
ram, osx 10.4 (pause-deep breath); i cannot seem to find out how to
import files in excel from other (windows) sources; the message balloon

When I open a new workbook, or even a current file, the window itself
opens too large for my screen and I have to scale it down.  Is there
any way to change the default setting so that I don't have to do
conitnually do this?

Whenever I option-click a cell in Mac Excel version 11.2.3, it performs
a "insert row, shift cells down" operation. I thought it was some kind
of incompability with my third-party keyboard and mouse, but I tested
in an iMac with original keyboard and mouse, and it showed the same

Attempting to convert lat/long from degrees minutes seconds (dms) to
decimal degrees (dd). That is, I have data in dms and enter that into
columns of latitude and longitude. I want each cell to convert the dms
to dd.

I've got a new problem that cropped up in Excel 2004 on Mac PowerBook G4, OS
X 10.3.9.
In some spreadsheets, a reference in one cell to another cell's text returns
the formula, not the text in the other cell. In other words:

When I looked for Graphic Filters in the Office:..:Shared
Applications:Graphics Filters folder, I found none. Where can I get
these?
I need them to save jpeg, gif, etc images of spreadsheets parts. See

I have 2 G4 powerbooks both running excel 2004 and OS X 10.4
On one of them when I hook up an external keyboard, the numeric keypad works
fine for entering numbers
On the 2nd powerbook, when I connect an external keyboard, the numeric

Today I can no longer obtain a fill handle by pointing to the lower
right corner of a cell; the cursor does not change. I've quit and
restarted with a blank worksheet, and loaded last week's Office
upgrade, but all to no avail. I have no idea why this has happened. Is

Can any one help me.  I've been dealing with this problem for as long
as I can remember, and it's getting worse.  Occationally, when waking
the computer from sleep, or for no apparent reason, office will freeze.
when I attempt to force quit, the excel icon disapears from the

What function/formula can I use to return the previous month. Let's say cell
A1 contains the word  August.  What can I put in the next cell to return
July. But will also give December if January is in A1.  I am currently doing
it with the following convoluted vlookup & I'm sure ...

I have a wksht that is shared among several different users across different
systems and platforms.  Due to varying screen sizes, resolutions, etc. not
all users can see the full intended screen view (cells a1:H24, named
"Introscreen") without making zoom adjustments.

I've recently upgraded my G4 iBook to a MacBook and one of the only
noticeable quirks has been two things to do with Excel.
When I try & open an .xls file that is on the desktop I get the following
error:

In a 600 or so row spreadsheet, in one column, about 15 % of the cells
have content.  The numbers of contiguous empty cells in that column vary.
I need to automatically fill the empty cells with the contents of the
cell above them.

Followed the steps in Help to bring in from Excel. When Excel data
appeared in my Word document the gridlines were greyed out and did not
show when I printed the Word document.
How can I get them to show when printing the Word document ?

I'm using Excel on a Mac and see a lot of value in "Save as Web Page"
to move workbooks to one or more of my web sites.
My first experiment worked very well, in that the formatting and
content at the site look very much like my original in Excel.