Excel shortcuts let you quickly maneuver through your window, perform procedures, access user forms or help you preform some excel action with the press of a few keystrokes.
Here is a full list of shortcuts, published by Microsoft. However, if reading through pages of information isn't your thing, here is a shortened list of all the single press shortcuts.
If an Excel shortcut does not already exist for something you do regularly, you can record a macro that does that something and assign a particular code to it.
For example, let's say you have a workbook with multiple worksheets and you always find yourself having to go to a particular sheet (maybe because that is where you keep all your assumptions). You could record a macro that always takes you to the first sheet.
In Excel 2007, you will need to make the "Developer" ribbon available by going into Home > Excel Options > Show Developer Tab in Ribbon. Before you begin recording make sure you are on a different sheet than the one you will want to always switch to. Start the record wizzard:
Give your macro a name ("AssumptionSelect") and enter a shortcut key ("CTRL" + SHIFT + H). [NOTE: be careful not to pick a shortcut that exists because you will overwrite it] Then select whether you want this macro to live ONLY in this workbook or in your instance of excel (so you can always use it, for the specific thing we are recording here you should save it to the workbook only). Click OK to start recording. Select the "Assumption" tab of your workbook and stop recording.Now whenever you want to go to your assumption tab, just enter your shortcut keys and you are there.
Attached is a workbook that has this macro stored into it.
As always leave me your questions/comments/and future blog ideas.
-Danny
Posts
