Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014

8. Ctrl-F4: Close the active workbook (but leaves Excel open). You’ll be asked whether to save unsaved changes.
 
9. Ctrl-Tab: Switch between open workbooks. This is interchangeable with Alt-Tab which also allows you to switch between open programs. You can also use Ctrl-F6, which is how you switch between open windows in Word, PowerPoint, and Outlook.
 
10. Ctrl-Page Down: Navigate to the next worksheet to the right. Or, in a large workbook, hold down Ctrl and press Page Down repeatedly to move several worksheets to the right.
 
11. Ctrl-Page Up: Navigate to the next worksheet to the left.
 
12. Ctrl-1: Open the Format Cells dialog box. Many, but not all, formatting commands are available by way of Excel’s toolbars and ribbon interface, but in Excel 2007 and later this means continually returning to the Home tab. Ctrl-1 launches a Format Cells dialog box from anywhere in a worksheet, no matter which ribbon tab is currently active. 
 
13. Ctrl-A: Select the current region. Another way to do so is to press Ctrl-*. For the uninitiated, the current region is the contiguous block of cells that surround the currently selected cell, bounded by the worksheet frame and the first adjacent blank row and column. Press Ctrl-A a second time to select the entire worksheet. You’ll also often find me holding down the Shift key while I select an area of the spreadsheet with the arrow keys, or sometimes Page Down, depending upon the number of rows involved.
 
14. Ctrl-Home: Return to cell A1. Return to the top left-hand corner of any worksheet in a flash rather than incessantly pressing Page Up or tinkering with Excel’s scroll bars.
 
Your list of fourteen keyboard shortcuts will likely differ from mine. The Microsoft web site offers comprehensive listings of keyboard shortcuts from which you can develop your own time saving tricks:

David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.

 

You may like these other stories...

There's thunder and lightning in the cloud these days. And the rumbling is all about security. Could peer-to-peer file transfers be the answer? As the old accounting adage goes, there's more than one way to skin a...
Saving Excel spreadsheets as PDF files has gotten incrementally easier over the years, but can still require more effort than necessary. When saving a document as a PDF, many users go through several mouse clicks on the File...
Imagine being able to file a business expense, such as a cab ride or a meal with a new client, in real time from an app on your smartphone. Here’s the best part: Imagine being reimbursed for that expense in 24 to 48...

Already a member? log in here.

Upcoming CPE Webinars

Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.
Nov 18In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets.
Nov 19How do you minimize redundant work and unnecessary steps to maximize the amount of work moving through your firm?
Nov 20Kristen Rampe will share how to uncover new opportunities with your clients by asking powerful questions.