Mac Forum / Applications / Excel / July 2008

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I highlighted several columns and formatted them with borders. That formatting goes on for an infinite number of pages. My spreadsheet only takes up about 4 pages. How can I eliminate the formatting that goes on ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
To my surprise, I couldn't find the Pivot Chart feature on Excel for Mac... Is that possible? MS did not provide this basic feature in the Mac package?

How can we look for a number in different spreadsheets? For example, I
have 10 spreadsheets in a workbook (all of them with data) and I want
to look for a number or a name while I do not know in which
spreadsheet this numer or name is, how can I look for it? I know we

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
I have just upgraded to 2008. in my earlier version I often got the message 'No more fonts may be applied to this workbook' annoying but I could still save my work.
NOW when the same message appears (I had hoped it wouldn't) ...

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
I am a beginner on excel and I am trying to see if there is a formula available that allows me to calculate a beginning balance, deposits, checks, and end balance on the same row.

Version: 2008
HOW DO I REMOVE HYPHENS IN SOCIAL SECURITY NUMBERS IN A COLUMN IN EXCEL?

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
wwe have been experiencing an issue with only certain workbooks in MS EXCEL 2004.

I need to know how to update a column of numbers (dollars & cents values) in
MS Excel.
I have a rather large/long column of numbers consisting of dollars & cents
in MS Excel -  I want to be able to select a certain number of cells/rows in

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I have a data base with many song titles and I want to find all the titles with the word warmth or snow in it.

Recently I asked if there were any "Best Practices" for working with
pivot tables in Excel 08.  As I'm just starting a new project, and I
didn't get a response to me early question, i thought I'd ask some
specific questions:

In Excel 2000 I've tried to use the formula: =IF(J12="Yes",WORKDAY('Start
Here'!E22,3,'Start Here'!H24:K24),"Not Applicable") and get a #NAME? error.  
The Help menu indicates I've used the right syntax for WORKDAY, but does not
have a solution under #NAME? for why the error ...

I am using excel 2008. I understand that the formula bar would float and
cannot be docked. But in my case it is 'somewhat' docked - it overlaps the
formatting toolbar if i choose o view the formula bar and i cannot move it
from there. What i have noticed that all the floating bars ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
SCENARIO 1: this works fine

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I would the x-axis labels to appear only for the x values in the data set. Is there a way of doing that?

I'm running Excell 2004 for Mac, version 11.5, running on an Intel MacBook
under OS 10.5.4.
When I use the arrow keys on the keyboard, the screen scrolls across but the
cursor does not move from one cell to the next, which is very frustrating.