Mac Forum / Applications / Excel / August 2007

When I print, the page number shows up on the right side of my paper.
I don't need this.  How do I disable that feature?
dzelnio

I have a list of about 10 rows that I want text (from drop down boxes) to be
entered into.  Once each cell within that list has something entered into it
I want the top row to say 'Complete'.  Is there a formula to do this?
Thanks

Is there a way to bring only certain cells to the front worksheet depending
on the text in a certain other cell?
I have one worksheet that has all the information about jobs to track.  on
the front worksheet of that workbook I would like to show just those jobs

I recently edited a worksheet in my workbook. I added some rows across
the entire sheet and moved and deleted other rows in a similar manner.
I saved a copy prior to this activity. When I opened the workbook the
next time I noted that Excel did a hard crash (generating a report

I just started using Excel on a MAC and the active cell is a shade of
light blue that makes it very hard to find.  Is there a way to change
this color so that it is easier to fing which cell I am working in?

Hi, I added a footer to my Excel 2007 spreadsheet.  When I go to print
preview I see the footer as well as all my text entered into the spreadsheet.
Once I go out of Print Preview my spreadsheet is blank?  The data is still
there but I can only view in using Print Preview.  ...

I need find a formula to identify duplicate numbers in a column being either
a debit or a credit.  For example:
          A                        B
     1234.00            duplicate

In Excel 2003 it seems to be impossible to insert a hyperlink in a cell when
the workbook is shared and protection of the worksheet is on (even though the
protection of the worksheet explicitly excludes the insertion of hyperlinks).
Is there a way to circumvent this?

How do I make a worksheet convert all links to values?
dzelnio

=IF(AND(V2="monthly",Y2="January"),$U2)
works great when statements are true.  How do I say "if false then
leave the cell alone?"

I'm having a problem with the SUM function that I hope someone can help
me with. I'm running OS10.3.9, with Excel 11.3. I have a row of numbers
followed by two SUM functions that each add up half the row; e.g., in
cell G4 is "=sum(a4:c4)" and in cell H4 is "=sum(d4:f4)". The problem

I am having a Senior Excel moment
I have a array covering lines 4 to 4427
Column X can contain one of A-1, A-2,Š.A-10, ŠG-10
Column Y can be blank or contain R1 or R3

Hi. I'm using Excel 2004 on a iMac G5 with the latest OS and updates
etc etc. My Microsoft preferences have been trashed and I've repaired
permissions.
I rarely use Excel and only in the most basic way. But today I'm

My rows go like this:
    A           B        C     D       E            F
Job name   Jan    Feb   Mar   Apr   Page number
ABC job       -      ABC    -     ABC         8

Okay... I have a problem that I think is impossible to solve:
I have text written over 4 horizontally merged cells (a short paragraph of
4-5 sentences).  When I view them in "normal" view, they looked fine (text
wrapped, left aligned, etc.). However, When I print the worksheet out, ...