January 2011
13 posts
Preferred File Location in Excel for Mac
Excel can save files in a directory of your choice every time. Open Excel for Mac (2011 or 2008) and choose Excel > Preferences, select the General tab, then click the Select… button for the Preferred file location, find the folder of your choice and click Choose, then click OK.
Try Excel 2011 Free for 30 Days [Mac] →
Check out Office 2011 free on your Mac for 30 days by simply registering.
Convert Volatile to Static Time in Excel
The Now() Function will provide a dynamic time that changes much like the RAND() function does. If you want a static time, use the keyboard shortcut Ctrl+; (semicolon) which will put the computers system date in the active cell.
The Name Box in Excel for Mac
If you can’t find the Name box in Excel 2011 or 2008 the Formula bar will need to be in full view by choosing View > Formula Bar.
Get Rid of That Hyperlink in Excel
When you want a hyperlink, without the hyperlink there’s a simple solution. Just type a hyperlink into a spreadsheet cell, then use the keyboard shortcut Ctrl+Z to remove the link. The text remains in the cell, but no more hyperlink.
Sweet!
SkyDrive Excel File Link Not Working with iPad
I’m having all kinds of trouble trying to access an Excel spreadsheet that’s located in a public folder on my Windows SkyDrive account with my iPad. Even though it’s public, I have to sign-in to see the file, but can’t interact. Then after signing out and following the link a second time the website kicked me into a mobile view, which is slightly horrendous and has no...
Importing Data from a Web Page
I’ve been trying to do things equally across both Excel platforms - Windows and Mac - but importing data from a web page is something that the Windows version (Excel 2007, 2010) has going for it that’s lacking in the Mac version (Excel 2011).
Some of this is frustrating as hell.
Keyboard Shortcut for Number Format
The keyboard shortcut Ctrl+Shift+1 works in both Windows and Mac versions of Excel to apply the Number format with two decimal places, thousands separator, and minus sign for negative values.
Zoom Excel 2011 for Windows Spreadsheets →
When I use Excel 2011 and open a spreadsheet that was created in a Windows version of Excel, I normally set the zoom to 125% because of the difference in column widths. Why can’t things just be standardized between the two?
View 2 Worksheets Simutaneously in Excel
Sometimes you find yourself switching back and forth between two different worksheets and would like to see them together at the same time. Just choose View > New Window, then select Arrange All, click an Arrange option (like Horizontal) and click OK.
Now you can see both worksheets in the same Excel Window.
Redo and Repeat Commands
The Redo command uses the keyboard shortcut Ctrl+Y, but so does the Repeat command. In Excel for Windows the F4 key is also used as a shortcut key for Redo/Repeat, but not in Excel for Mac. (You can fix the F4 button on the Mac.)
In Excel for Windows, the Repeat command icon can be added to the Customized Keyboard, which I find to be somewhat interesting.
Familiarize yourself with the Excel 2011 Ribbon →
Direct link to Microsoft Office:Mac HowTo Excel topic.
If you happen to turn off the Excel Ribbon using the instructions here, turning it back on is done through the Excel > Preferences > Ribbon dialog box.
