Mac Forum / Applications / Excel / March 2008

Hello,

I am attempting to do histograms in excel 2008. I know how to do it in the windows counterpart because of school, but I have homework to accomplish for the class and cant find the function anywhere in the mac side of business.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
How do I link columns 1,2,3 when I sort by column 1?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
How do I remove (or hide) the automatic page breaks. I almost never print my spreadsheets and the dashed lines are distracting. The help file says that they can be adjusted, but the only thing I can do is to ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Here's the situation:

New to Office on Mac... can't see the formula bar anywhere. Have been through Preferences and checked Formula Bar in View but can't find it. I have to assume I'm missing something very obvious - any help would be greatly appreciated.

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
I need to get an average value from a group of cells in which there may, at times, be non numerical values ( i.e. a letter instead of a number). The way I have done it (the "usual" way), when there is a non numerical value, I ...

Is there any way to change the default date format from MM/DD/YY to DD/MM/YY? It is important that I change it as New Zealanders don't use the MM/DD/YY format.
I have searched all the help files and can't seem to find anything

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Hi everyone:

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When in a current workbook and moving between tabs, excel opens a new workbook with the tab content that I have clicked from. Action to date is to delete this new workbook. This has been occurring 20 plus times ...

I have huge amount of data for latitudes and logitudes in excel and I was
told that they were in DMS format.. Bt the thing is excel doesnt accept my
format as there is no space in between values (DDMMSS or 522378) I noticed in
the other thread that excel only accepts if there ...

Right now, when I change the fill, it only goes down to 25% gray,
which is still pretty dark and too much contrast for my taste. How do
I get down to 10% gray.

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
We transferred office 2004 to another computer, now we can not use the personal macro workbook since is apparently is all ready open.
what can we do to resolve this problem?

I'm feeling really frustrated here, but can someone help me with requiring a
user to enter data in a cell before they can leave the cell?
I have a drop down box for the cell, and have unchecked 'ignore blank' in
the data validation, but I can still move past the cell without ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I don't understand why features from Office 2007 like conditional formatting with the icons etc, Table formatting, and Macros are not included in Office 2008! Why is a program dubbed one year newer to include ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I have searched throughout the mactopiaverse for my answer before posting my question, but couldn't find it anywhere....