0
votes
0answers
65 views

Make Excel Row Height Stay Once Sorted [duplicate]

One column has variable length data that may be one row or maybe a bunch of rows deep. (Actually another column does as well, but it doesn't get more than 3 rows deep). When I sort my spreadsheet, ...
0
votes
1answer
57 views

Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have: Starting Time B1: 09:30:00 am Ending Time C1: 17:00:00 pm Total Hours D1: =C1-B1 (06:30) I want to sum the values ...
0
votes
1answer
118 views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
0
votes
1answer
801 views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
2
votes
1answer
44 views

Excel opens all files in directory

Excel 2011 is behaving strange. When I open a file, Excel responds by opening all (.xlsx and .csv) files in the directory! I'm running OS X Mavericks. Tried several ways of opening: double click, ...
0
votes
1answer
105 views

Combine Excel worksheets despite adding new sheets

I have an Excel worksheet that works as template for a questionnaire. My aim was simply to copy the worksheet into a new one while preserving the formatting and other stuff, and I could then just fill ...
1
vote
0answers
557 views

Keyboard Shortcut to Fit Column Width to Text in Mac Excel?

I know this on a PC. It is Alt+O,C,A, as explained in this question. Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac? I'm ...
1
vote
0answers
29 views

Microsoft Excel on Mac unintentionally clears my cells

When I navigate through cells using the arrow keys I have encountered some annoying behavior. If I stop at some cell for a second or so, it automatically enters edit mode for that cell clearing ...
1
vote
1answer
6k views

Export CSV with values enclosed with double quotes

How do I export a CSV file where the values and fields are both enclosed in double quotes (") from Excel 2004 (Mac)? E.g. "Name","Telephone" "John Doe","555-5009"
1
vote
0answers
306 views

Excel on Mac doesn't show Chinese characters [duplicate]

Possible Duplicate: How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X I downloaded an Excel file, which is supposed to contain Chinese ...
0
votes
1answer
2k views

Activate spell checking in Excel - Office for Mac 2011

How can I activate spell checking in Excel in Office for Mac 2011? I would like to have spell checking just the way it is in Word or system wide in OS X.
2
votes
0answers
264 views

Can I disable Excel's warning when saving CSV files? [duplicate]

Possible Duplicate: Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format? Excel always says ...may contain features that are not ...
3
votes
1answer
205 views

How can I select the region that should be viewed in Word from an embedded spreadsheet object?

Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets ...
1
vote
1answer
4k views

Enter “return” in excel?

It took me a while to find out how to do it on Windows. Now, how do I do the same in Mac? What's the equivalent for Alt+Enter for Excel on Mac?