0
votes
0answers
66 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
181 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
398 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
3k 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
63 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
203 views

How to set a shortcut to “Customize Keyboard…” in Excel Mac 2011

I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut. Apparently we can't do do it via Excel because there ...
1
vote
0answers
733 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 ...
2
votes
0answers
265 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 ...
1
vote
2answers
3k views

Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...