Mac Forum / Applications / Excel / January 2008

This is sort of a bug that renders Excel unusable. You can reproduce the bug in very few steps. Open a blank sheet
Show the form toolbar
Create a horizontal or vertical ruler
Now try to click on the directional arrows of the ruler, or anywhere on the ruler... You'll see your

When I try printing a multiple sheet file to PDF (Acrobat 8) I seem to get exactly the (poor) result I got with Excel 2004 - namely it ends up printing one page only. Seems to go through the print process, "over-writing" as it goes along and ending up with the last page. I have tried

How do I save spreadsheets so all users are able to edit? When I create a spreadsheet and save under "shared" users, another user can access the file, but as "read only". Thanks!

HiNot sure if this has been mentioned before, but I have searched to no avail....I have a grid template setup where I have to draw diagrams of housing plans. In Office 2004, there is an option to "Snap To Grid" when drawing lines in Excel (so that all lines meet up and are square

On an Excel sheet with many formulas I created a drop down list by mistake. I
want to delete it. I tried following the online help but the "Convert to
Range" option was not active for me.

The ESRI program ArcView creates several files, one of which is a
*.dbf file.  Win Excel has no problem reading this file.  Excel 2004
for Mac won't.  Any ideas on how to open it?  Thanks.

I am making a large inventory list that I want to have available in a couple of sorted ways. One will be sorted by location, one by item, and one by category. Once this is accomplished I would like a sheet for each list, what I can't seem to do is; how do I make it so if I make a

Does anyone have an idea how I might go about creating a macro (or other solution) to enable me to generate a list of sequential numbers? I want to track an order book in an excel spreadsheet and allocate a new sequential number to each transaction.  Naturally I could just do this

I can't get lines with arrow points to print properly.  They look fine on screen, but when printed (either to a printer or to a PDF file), the lines are not centered relative to the arrows.  Or, the line will intersect the arrow point midway up or down the arrow lines, not where the

was looking forward to excel 08 to make the full switch onto the mac platform. in excel 07 (win) i created some invoice-sheets that use a light gradient fill of cells to seperate contents - that looks nice and is useful. unfortunately, excel mac 08 doesn't support gradient fills

I may have inadvertently changed a setting, cause I don't remember
this happening before.
If I enter a formula using a + sign, I get the result, not the
formula.  For example, +300/3 gives a result of 100.  A control+U

Does anyone know whether Excel 2008 can connect to OLAP cubes? (Or
where else I could find an answer to this question?) I emailed one of
the writers of the MS Mac BU blog, but never got a response.
thanks,

I think I might have found an autofill bug. You can't autofill a series
down closer than 2 cells above a row that has merged cells in the next
column to the right.
This also derails any applescripts (but without the error) that attempt

I have Excel Mac 2004 and want to organize specific  rows of data from different worksheets into a new worksheet.  Any suggestions on how to easily do this without cutting and pasting?  Thanks!

Hi everybody... can someone please tell me how to halt a formula in excel (by putting the $ in the cell)... I'm new with my mac and in the excel for windows you should just edit and type f4 in order to get the formula halted but I don't know how to do it with excel for mac... can