Shortcuts For Excel 2010 How To Quickly Get

Excel Keyboard Shortcuts: How To Quickly Get Or Create Any Keyboard Shortcut You Need.

Not knowing the right keyboard shortcut means that, instead of quickly typing the relevant key combination, you need to (i) lift your hand from the keyboard, (ii) reach for the mouse in order to do what you want, and (iii) return to the keyboard.

You can find this list of keyboard shortcuts for Excel here.

The list is also available for download as a free PDF file called Excel Shortcuts and Hotkeys: The Power Spreadsheets Cheat Sheet.

If you want to get the data from the PDF file into Excel, you can use any of these conversion methods (which you can also implement with macros ).

You may find that, from time to time, even massive keyboard shortcut resources (like my cheat sheet) dont list the keyboard shortcut for the precise item you need.

Knowing how to find or create a keyboard shortcut by yourself can be quite valuable in these situations.

This leaves out the options you have for creating custom keyboard shortcuts in Excel by using the Quick Access Toolbar or macros.

Even if we tried to learn them all, is likely that only a few of us would succeed.

My purpose with this blog post is to provide you with the knowledge you need to master keyboard shortcuts in Excel and become even more productive.

Therefore, in addition to explaining the different types of keyboard shortcuts that are available in Excel, I show you some methods you can use to create your own custom keyboard shortcuts.

The table of contents below shows the specific topics this blog post covers.

Most of us want to have them and, as I show below, lots of Excel bloggers and writers (including myself) have created their own version of them.

After all, you probably dont need to know so many keyboard shortcuts.

Furthermore, some of those shortcuts may be for commands or features that you rarely use.

You can rest assure that most other Excel users (including very advanced ones), dont know all the shortcuts either.

Youre unlikely to learn a huge amount of keyboard shortcuts in a very short period of time.

As you start gaining more familiarity with Excel keyboard shortcuts, youll be able to handle more.

My suggestion is that you take the following 2-step approach to determine what keyboard shortcuts to master.

Due to the broad variety of activities people carry out with Excel, this varies from person to person.

Your list of most commonly used commands may not look at all like mine.

However, depending on factors such as the type of command or tasks you need to execute and your own personal preferences, the keyboard shortcuts included in such lists may not (for different reasons) work for you.

In addition to the huge amount of built-in keyboard shortcuts that Excel has, you can create your own custom keyboard shortcuts (taking into consideration some requirements and limitations that I explain below).

Mac Shortcuts For Excel 2010