Mac Forum / Applications / Excel / June 2007

This probably isn't possible, but before I start doing this manually
I'd thought I'd ask...
I've a number of Excel files all in the same format (inventory) I'd
like to compile into one big spreadsheet. Normally I'd just open them

Is this possible or can I only add text footers in excel?  I want to add a
company logo to an invoice template I am working on.
Thanks,
gitane

I discovered that the dates were off on my excel files, and that I
need to uncheck the 1904 option in the preferences.
However, I am wondering, if there is a way to do this for all of the
excel documents I have, instead of having to go to every one

3000+ item list filtering for all items greater than 0 and using Advanced
Filter, telling it to copy to another sheet in the same workbook, by just
clicking on the sheet tab which fills in the Copy to: with "Inventory!" (no
quotes.  Then I get an error message that the formula ...

I have an IBook G4, and usually use an external keyboard which has a
'delete' key.
Is there any shortcut in Excel that clears the content of multiple selected
cells, without having to use the delete key? As the keyset on the IBook does

Stupid, stupid me.
Had my MacBook Pro on an external monitor with a very wide formula
bar.
Now back on the laptop screen (and can't get to a monitor) and the

Pressing the Home key selects the first cell in the current row. I'm looking
for a keyboard shortcut to get me up to the first cell at the top of the
current column. I've tried all sorts of variants of Home, such as opt-Home
and so on, and similar variations with the up-arrow. Can ...

I'm using a Mac with Excel 2004 and on one machine when you open a new file
it is displayed underneath the toolbars, not below them.  Is there a setting
to prevent this?

I'm trying to open a text file and have it import right. The company
who made it said:
you should import the text file as | delimited. Not tab delimited.
When importing into Excel, and it asks you to choose your delimiter,

simple query i know, but just wondered how you get excel spreadsheet
to record in pounds sterling and not dollars? when i used office with
a pc this wasn't a problem - i now use a mac and have office 2004 for
teachers and students. can anyone enlighten me please?

I cant figure out the sytax for a macro to delete rows that contain an error
in it.  Basically I have a spread sheet with links and formulas and I need my
macro to delete any rows that the formula in column g is an error.
Thanks,

Is there a way I can import data automatically from another Excel file
interchangeably?  In other words, if a cell in Spreadsheet A changes,
its corresponding cell in Spreadsheet B would also change?
Thanks!

I have a spreadsheet (Mac Excel 2004) that I cannot save. When I try
to save it, the colored wheel spins and Excel does not respond.
Eventually, I have to force quit.
Is there a fix? This is a very important spreadsheet that I use on a

Mastered the very basic data validation even using names!!. However I now
wish to use my product sales data worksheet which has 2 columns, how do/ is
it possible to have a drop down list as in data validation but for columns,
i.e., choose product 'a' and product 'a's sales price is ...

I am having a challenge with excel - the spreadsheets are still
useable, but I can not get my cursor into the cells without using the
arrow keys.  (when I try to use the mouse, a thick + shows up, this
used to be an arrow which would allow me to work within a cell.  I