Mac Forum / Applications / Excel / May 2010

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)

I have a set of numbers with 1000+ rows. Every other row is blank and I want to delete all the blank rows, how?

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

whenever i zoom from 100% to anything higher all the numbers that are made by formulos become "xxxxx" even if i double click make the cel wider the xxx dont go away. how can i fix this?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is there a short cut that allows me to select the top row off my sheet and then jump to the last row so I can highlight the entire sheet, scrolling through 15000 lines is slow and tedious. Thanks

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

After copying/pasting a number of objects within a spreadsheet, paste stops working -- it's grayed out in the edit menu and crtl-v no longer works. Pasting content within cells continues to work --

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Today is the 30th of May.  I'm working on multiple projects and would like to see how many days I have to complete them.  It appeared DAYS360 could help me do that.  Unfortunately, it seems that DAYS360

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I have just loaded Office 2008 and then update to the latest update 12.2.4  
I have my system preferences set to Australia for date and time using the date format dd/mm/yyyy. But in Excel when I open

Operating System: Mac OS X 10.6 (Snow Leopard)

Hi, I've just loaded Excel onto my Mac and have been trying to do some conditional sums, however for some reason it will not allow me to display the totals on a separate sheet. It just keeps saving to the same sheet as the table, even

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Lets say I type "a b c d" into a cell.  Is there a way I can place the cursor between "a" and "b" and then cause only "a" to remain in the original cell while

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)

How can I copy same info between worksheets?

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)

How can I "automatically (or shortcut) move between worksheets without having to click on them?

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I am seeing a previous cell comment when I mouse over another cell in a different column of cells. It only happens in the one column and its the same cell comment. How can this situation be fixed so I will

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

When you open spreadsheets incorporating pivot tables originally created in Excel 2007 for Windows the numbers turn to Ref! and Value! error messages.  Having bought a new Mac and a new copy of Excel

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I am running OS Snow Leopard (10.6.3) on a Mac Pro Quad Core Intel machine.  The problem I have is with ALL Microsoft Office 2008 applications though the worst is with Excel.
Word, Excel, Entourage

Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Looking to purchase an imac for home use and also want to learn VBA in XL for work proficiency.  Based on the VBA 2008 issues, what would you suggest to be the best environment to learn VBA... A. Wait for new Office

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Is there a way to independently format the width of a column on specific cells? In other words, if I wanted to change the width of the cells in the middle of the document, can I do so without affecting