Questions tagged [microsoft-excel-2008]
The 2008 version of Microsoft's spreadsheet application for OSX.
15
questions
-1
votes
1
answer
88
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 ...
- 11
0
votes
2
answers
38
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
1
answer
408
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 ...
- 222
0
votes
0
answers
50
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 ...
- 101
3
votes
2
answers
16k
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
1
answer
325
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
1
answer
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?
- 21
40
votes
6
answers
327k
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 ...
- 779
1
vote
1
answer
718
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'...
- 147
2
votes
2
answers
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 ...
- 117
1
vote
3
answers
1k
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
- 428
2
votes
3
answers
3k
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 ...
- 83
3
votes
2
answers
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?
- 681
0
votes
1
answer
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,233
1
vote
3
answers
5k
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 ...
- 1,490