Mac Forum / Applications / Excel / May 2007

I am not sure if this is possible, but I will leave up to you experts. My
questions is: Can you view the Header on a each page of an excel spreadsheet
without print previewing?  How would you do this?
Is this possible? I think this may be a interesting question, but I thought

We have several workstations in my department, all equipped with MS
Office 2004, running on Mac OS X Tiger. One person experimented twice
the following problem, with Excel sheets she received by e-mail.
She can open the document and work with it, but when she does a "save

My macro copies and pastes a lot of data ranges between sheets and the screen
flashes as it does all this.  I know there is a command to not have the
screen flash but I cant find it.  Doesn anyone know it offhand?
Thanks,

I am using excel 2003 sp2.
How can I  Calculate Elapsed Total time in Column G
ColumnE  columnF   columnG - formula in G is =F46-E46+IF(E46>F46,1)
starttime    complete  time elapsed

I have figured out how to add hours, but how can I substract hours
Used from hours allotted?  For instance, if a task took 4:15 hours to
complete but was allotted 6 hours to complete, how can I create a
column to calculate how many hours were utilized and how many were

=J9-B9-D9-F9-H9-L9
This formula is in the cell I want to filter. It shows $0.00 because nothing
is in j9 etc. yet.
If I do custom filter do not show contains $0.00, cells containing $0.00

I am faced with a problem to merge columns. I need a Macro that will
do the following operation. This is how my raw file looks.
Sample #    CD1    CD2    Sample #        CD3  Sample #    Cd8a2    Sample #    Cd8b7
B1234567    400    100    B1234567          6.1   B1234568     5.1

on macintosh os x version 10.3.9 and ' excel x for mac service release
1' copyright 2001 i sort spreadsheet with about 540 rows on column1
'a' which has numbers between 70000 and 2e9.  the sort routine appears
to sort the first 512 rows correctly.  the final forty rows are also

On my PC i can format column headings with month and year which are filled
accross the page. On the Office for Mac 2004 that i have just started using i
cannot get this date format to work. All that i get is the serial number. The
only format that i can get includes a day as well ...

Sub DeleteNonSubcontracts()
Dim wsheet As Worksheet
For Each wsheet In Worksheets
       If wsheet.Range("D10:O10") <> "" Then

I had to go back to 2002 in the archives here to find this question,
which is pretty much the same as mine...
Is there a way to convert the old Excel 4 macros to VB macros?
The answer then was, no, you have to re-write them. I'm wondering if

I would like to make my row headers show up on all subsequent pages.
Right now the header row is in row1 -- this describes all the info in each
column ..  and is not at the top of each page subsequent page.
Hope you can help.

Just wondering if someone could point me in the right direction?
I have created a job countdown spread sheet in excel for different companies
I work for (it simply counts down the days to go before I have to do a job)
On the countdown cell on each sheet, I have stuck a conditional ...

Our Office was using 10.4.7 and office 11.2.3 I ugraded all macs to
10.4.9 and Office to the latest offering via auto update (ran it until
it said nothing to update.)
Now workbooks on our server cannot be updated they can be opened but

I am switching from PC to Mac.  I have a Mac Book with MS Office 2004
for Mac installed on the Mac Book.  On an external drive I have a
multitude of doccument files created in MS Works 4.5 stored as wps
files.   Is there a downloadable converter file that works on Mac's