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

**0**

votes

**0**answers

16 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

**0**answers

126 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 ...

**0**

votes

**1**answer

28 views

### how can I select the drop down fill-in text with keyboard (excel2008)

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 add ...

**2**

votes

**1**answer

533 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

**5**answers

49k 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

**1**answer

561 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 ...

**2**

votes

**2**answers

4k 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

**3**answers

688 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

**3**answers

1k 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

**2**answers

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

**1**answer

929 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

**3**answers

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 ...