|
flevyblog
The Flevy Blog covers Business Strategies, Business Theories, & Business Stories.
|
Editor's Note: Take a look at our featured best practice, Project Management Workbook (Excel workbook). This is a functional workbook that allows users to plan and track projects against requirements gathered as part of a program. It is versatile enough and customizable to be useful for any type of project. For example, it can be used to document strategic initiatives, define governance and [read more]
* * * *
There are 3 things that separate the struggling Excel monkey from the seasoned one.
This article will discuss the first group–shortcuts. I’ve compiled a short list of “not-so-obvious” Excel shortcuts. These are also the shortcuts I find myself using most often.
Navigation Shortcuts
| Ctrl + arrow | This is the shortcut I use most frequent. Hold down “CTRL” and hit the arrow key to jump to the edge of the next data region (in the direction of the arrow key). If you’re unfamiliar with this shortcut already, test it out. It’s a bit difficult to articulate in words. |
| Ctrl + Shift + arrow | Achieves the above, while highlighting your selection. This is most often used in conjunction with other shortcuts (e.g. preceded with Copy and proceeded with a Paste). |
| Ctrl + Page Up Ctrl + Page Down |
Jump to the previous sheet (to the left). Jump to the next sheet (to the right). |
| Ctrl + Home | Jump to the top-left cell of the sheet. In most cases, this is “A1.” Exceptions include if rows/columns are hidden or the sheet has frozen panes. |
Custom Quick Access Shortcuts
One of the greatest improvements in Excel 2007+ is the ability to customize the Quick Access Toolbar. The Quick Access Toolbar refers to the section at the top-left corner of the Excel interface (see screenshot below). You can customize this toolbar by right clicking on it and selecting “Customize Quick Access Toolbar…” From there, you can add, remove, and re-order shortcuts. I’ve only added 2 shortcuts here.
 Alt + 1 |
This is the “Format Painter” shortcut. I often use this shortcut in conjunction with “Ctrl + Shift + down arrow” to extend the formatting of a cell down the column. |
 Alt + 2 |
This is the “Paste Values” shortcut. Prior to this trick, accessing the “Paste Values” function was a fairly cumbersome process. |
 Alt + 3 |
This is the “Paste Formulas and Number Formatting” shortcut. This functions allows you to copy and paste everything, except the cell formatting (e.g. borders, background color, font color). This is useful if you already have your spreadsheet nicely formatted and just wanted to overwrite or extend some existing formulas. |
Random Shortcuts
| Ctrl + click sheet name + drag tab | Many times, you will need to duplicate a full sheet. The easiest way to do this is to hold down “Ctrl,” click the sheet name (i.e. click the tab), then drag it. |
| Ctrl + click sheet names + make edits | Sometimes, you may want to make the same changes across multiple spreadsheets. Prior to knowing this method, I would replicate the change across the multiple sheets manually. With this shortcut, you can make changes across the sheets simultaneously. Once you have the multiple sheets selected (note the color of the tab will lighten), pick any one of these sheets and make your edits. |
| Alt + H, M, C (Letters pressed consecutively) |
Merge and center selected cells. |
| Alt + H, O, R | Rename sheet. |
Use a shortcut that’s missing from our list? Please share in the comments section below.
A great way to learn Excel–including pivot table usages, advanced formula nesting, and VB programming–is by studying robust models that have been built by other business professionals. You can find Excel models of all shapes and sizes on Flevy here. Here are a few examples:
For a comprehensive list of Excel shortcuts, check out this page: http://shortcutworld.com/en/win/Excel_2010.html. Also, if you are an avid user of PowerPoint, read my list of Not-so-Obvious PowerPoint Shortcuts.
You can download in-depth presentations on Excel Project Plan and 100s of management topics from the FlevyPro Library. FlevyPro is trusted and utilized by 1000s of management consultants and corporate executives.
For even more best practices available on Flevy, have a look at our top 100 lists:
These best practices are of the same as those leveraged by top-tier management consulting firms, like McKinsey, BCG, Bain, and Accenture. Improve the growth and efficiency of your organization by utilizing these best practice frameworks, templates, and tools. Most were developed by seasoned executives and consultants with over 20+ years of experience.
