The 2008 version of Microsoft's spreadsheet application for Mac.

learn more… | top users | synonyms (1)

1
vote
1answer
109 views

In Excel for Mac (2008), how do you display characters that are converted to “#” symbols?

I am using Excel 2008 for Mac (I am also trying to work using the newest version of Excel on my computer, but it keeps crashing). When I open the spreadsheet that I need to work from, some of the ...
0
votes
0answers
20 views

Map 2 spreadsheets

I have two spreadsheet. Both spredsheets have an email field. Spreadsheet 1 has 400 email fields and the other has 1000 email fields. The 400 emails are in the 1000 email spreadsheet. The 1000 email ...
0
votes
0answers
148 views

Trouble with IRR formula in Excel 2008 on MacBook

I am getting an error message for a relatively simple calculation. I am trying to calculate the IRR over a 2.5 year period for a set of data in which -11,000,000 is the initial investment and zero ...
1
vote
2answers
6k views

Can I link images using a relative path?

I am working on an MS Excel workbook that contains around 200 images. They are currently saved within the workbook, so the file becomes huge and working gets very slow. Linking the pictures without ...
0
votes
1answer
34 views

How can I select the drop down fill-in text with keyboard in Excel 2008?

I have a spreadsheet of files and when I need to insert new filenames, Excel very handily produces a drop down list of similar entries. Pressing enter autofills, but then I have to click the cell to ...
2
votes
1answer
719 views

Graph with uneven spacing in excel

I need to make a graph of follow-up data at 0, 6, 12, and 24 months. Excel for Mac 2008 puts the 24 months at the 18 month position. How do I get the correct spacing without including 18 months?
4
votes
5answers
68k views

Excel: convert a column with hyperlinks to just display the links

In Excel, I have a column of links that display text instead of the actual link. I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I ...
1
vote
1answer
619 views

OS X Excel 2008: Export All Document Sheets to Separate Tab Delimited Files

Is it possible to bulk export multiple sheets in an Excel Document to separate tab-delimited text files? As it is, it only exports the active sheet. I've got a document with 850 sheets, all of which I'...
2
votes
2answers
5k views

Plotting discontinuous graph in Excel - Mac 2008

have some data that has gaps in it and Im not able to plot it in excel. I know I want to uncheck the "Leave Gaps" item in the Tools / Chart / Options panel. Plenty of googling has showed that that's ...
0
votes
3answers
719 views

Import CSV - file origin missing a UTF8 entry

Excel 2008 for OSX seems to be missing a UTF8 import No matter which I choose I get garbage for diacritics the file is showing fine in TextWrangler which reports it is in UTF-8
2
votes
3answers
2k views

Change line endings and delimiter format (permanently) when saving to CSV from Excel

I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to "," Is there ...
3
votes
2answers
1k views

How do you show the toolbar in Excel 2008 on Mac OS X Lion if it's hidden?

In Snow Leopard and earlier, there was a "tic-tac" control in the top right of the window, but after upgrading to Lion, it's no longer there. Any ideas?
0
votes
1answer
1k views

Is there any way to make the formula bar in Excel 2008 on Mac OS X 10.6 dock or attach to the window instead of floating?

Is there any way to make the formula bar in Excel 2008 on Mac OS X 10.6 dock or attach to the window instead of floating? So far everything I've read says no, but maybe you know the secret!
1
vote
3answers
3k views

Why is my Excel document printing on legal paper, but with letter margins?

I am trying to print an Excel spreadsheet, which is rather large. I want it to be only one page wide, and as many pages tall as is necessary. I want the font to be as large as possible, as long as ...