Keyboard Shortcuts

Control + Home in Excel for Mac

June 30, 2012 Features

One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years. I finally decided to do something about that and recently figured out a solution using VBA and the Personal Macro Workbook. But before I go […]

Get the full story …

Select Excel’s Used Range on a Mac

March 20, 2012 Beginner

I recently read a good blog post over at Contextures about selecting the actual used range on an Excel sheet, both manually and with VBA. However, using Excel on a Mac makes you keenly aware that there’s no Home button. The used range on a worksheet starts with cell A1 and ends with the last […]

Get the full story …

Import Data From the Web in Excel

January 28, 2011 Intermediate

Excel 2010 and 2007 for Windows have the option to import data from the web. Excel for Mac users don’t. An integral part of working with Excel is using keyboard shortcuts. They make your life so much easier (in the Windows versions at least, in the Mac version I think they tend to shorten your […]

Get the full story …

Copy a Help Topic URL in Excel 2010

January 26, 2011 Beginner

Excel 2010 Help is normally connected to Office.com so each Help topic has a specific web address (URL) that can be easily copied. This is only for Windows computers running the latest Excel version 2010. You can check the connection status to Office.com by hitting the F1 key to bring up the Help screen, then […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …