Questions tagged [microsoft-excel-2008]

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

Filter by
Sorted by
Tagged with
-1
votes
1answer
85 views

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 ...
0
votes
2answers
36 views

Type of CD needed [closed]

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'...
1
vote
1answer
210 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
44 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 ...
2
votes
2answers
11k 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
36 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
2k 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?
20
votes
4answers
179k 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
696 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
9k 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
815 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
2k 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
4k 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 ...