Super User Stack Exchange
Super User Stack Exchange

Questions tagged [microsoft-excel-2008]

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

Included in Microsoft Office 2008 for Mac, it replaced Office 2004 for Mac. It is the MAC OS X version of Microsoft Excel 2007.

15 questions
39
votes
5 answers

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 will have to click on each link, open it in a…
nicole
  • 769
  • 3
  • 10
  • 15
3
votes
2 answers

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 saving them works very well -- I now have the…
Port Islander 2009
  • 31
  • 1
  • 1
  • 3
3
votes
2 answers

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?
John Douthat
  • 671
  • 1
  • 10
  • 22
2
votes
1 answer

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?
Marius
  • 21
  • 2
2
votes
2 answers

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 the answer I want. But, I'm using Excel 2008 for…
Paul Cezanne
  • 117
  • 1
  • 11
2
votes
3 answers

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 a way to set the preferred CSV save format…
Dan
  • 83
  • 3
  • 8
1
vote
1 answer

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'd like to get exported as tab-delimited.
Keefer
  • 147
  • 1
  • 9
1
vote
3 answers

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
mplungjan
  • 428
  • 6
  • 22
1
vote
3 answers

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 it is only one page wide. So, in the print dialog,…
pkaeding
  • 1,470
  • 3
  • 18
  • 27
1
vote
1 answer

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 cells seem to contain too many characters, and are…
MicroMachine
  • 222
  • 1
  • 3
  • 16
0
votes
1 answer

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 add in further text. Any way to accept the auto…
Gillian van Niekerk
  • 1
0
votes
1 answer

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!
Philip
  • 1,213
  • 1
  • 21
  • 36
0
votes
2 answers

Type of CD needed

I have made an excel spreadsheet for membership information for a club. I want to make cd's that I can mail to individual club secretaries that can be filled out with the required information (members' names, addresses, etc.) and then returned to me…
Kay Southern
  • 1
  • 1
0
votes
0 answers

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 spreadsheet has more columns of data that the 400…
user979331
  • 101
-1
votes
1 answer

How do I extract data by filtering on a list of criteria?

I have an Excel problem that I don't know how to approach. Let me explain the scenario. Column A is populated with Name, which has both First & Second Name. I need to filter records based on multiple criteria, skipping those Names that contain an…
gardener
  • 11
  • 1