Mac Forum / Applications / Excel / October 2007

In Excel 2007 (Microsoft Office Home & Student), I can create and open a file
with no problem, initially.  The problem only occurs when you try and re-open
the same, or any other Excel file.  The program opens with a blank (light
blue) screen with the Customize Status Bar ...

Is there a way to write a formula to copy both the content AND
formatting of another cell?
I specifically want the text color to also be copied over.
Here's how I've copied the cells:

I have an assistant who is making calls for me. He is frustrated with Excel,
and is wondering if it can function more like a Customer Relation Management
tool and less like a  spreadsheet application.
Can excel do this?

Got a file from someone that he says is " Microsoft Works Excel " and
it's name ends in .wps.
Can't open it . I have Excel X for Mac on a MacBook Pro 17 Intel
running Tiger.

I am trying to write a formula that will place a phrase on my invoice if the
statement is true.  So far I have =IF(B28>=1,Planted and Guaranteed for 1
Year²).  I need this formula to also look at B29 and follow the same logic
test, but not duplicate the phrase if both cells are ...

Ive sen it done before where you can click a "clear" button on a
spreadsheet to clear data from a select set of cells, rather then
individually clearing them. I know i need to set up a macro but i dont
know how this is all done. Can someone bring some sort of clarity?

I want to increase the vertical space, (top and bottom) between the text and
the top and bottom lines of rows.  I know I can set the row height to a fixed
value to make this work, but when I put in text that is to "wrap" and go to
the next line in a single row, the row does not ...

I want to make changes in the default template that creates a new workbook
in Excel. But I can¹t find it. Greatfull for all help.
I have OS X 10.4 and Office 2004.
Svante

On the PC I can replace markers on a a line chart with pictures.  I want to
duplicate this on the MAC.  First, I can do this for a column chart without a
problem.  However, when I try it for a line charts the pictures get a
background fill, say a large white square with the ...

Excel 2004 (Office 2004) on a new core duo iMac with 2 gig of RAM, OS
10.4.10
reports that is low on memory and that a file must be closed and reopened.
This happens quite frequently.

I have recently encountered a very perplexing problem.  When I open
Excel everything seems normal and sometimes it will open a file as it
should.  These are all .xls files.  If I try to open a second file the
program hangs up with a blank inage of the file on the screen.  My

How do I do a scattergram where each data point has an x value for time, a y
value for "market capitalization" and a data label for  each stock.
This should be easy but I'm going crazy
I can't seem to get the data labels to come up when the each data point is

I need to know how to calculate gross payment using the if function and
calculate it with overtime if logic is false

I'm having trouble accessing cells in a spreadsheet created in Windows
Excel. There are a number of cells that should be protected and are,
but I also don't have access to over half the cells I should have
access to. These cells are not protected when the document is opened

I can't seem to break links in a workbook.  I go through the process
starting under "edit...links", select Break links, It gives me a
warning, which I OK and nothing happens.  One thing I notice is that
the update button is selected as Automatic and Manual is dimmed or not