Additional keyboard shortcuts to increase your productivity

Keyboard Shortcuts

Author:

Aroop Das

Published:

30 Jan 2018

Comments:

8 Comments

Category:

We are launching a new version of F1F9’s keyboard shortcuts. You will find them available to download in an Excel workbook just below.

Download the F1F9 keyboard shortcuts

The shortcuts are stored as macros in the workbook. On opening the workbook, you may need to click on “Enable Content” or “Enable Macros” to make sure things run properly.

Once done, the keyboard shortcuts will be active if the workbook is open.

Tip: save the F1F9 keyboard shortcuts workbook to a folder on your desktop called “F1F9 Macros”

Using the keyboard shortcuts

F1F9 has designed additional shortcuts to increase a modeller’s productivity. You do not have to use them to build a financial model, but many of our training clients tell us that they find them extremely useful. For example: Ctrl + Shift + A will copy the contents of a selected cell across all remaining visible columns in the row of that selected cell. That’s useful if you are building a model with consistent formulas.

You can test the shortcuts by having two workbooks open at the same time: F1F9’s keyboard shortcuts and a blank workbook.

Switch between the two workbooks using Ctrl + Tab (that’s a standard Excel shortcut).

In the blank workbook, type a number in a cell of your choosing, tap “Enter” and then copy across the selected cell using Ctrl + Shift + A.

You will find a list of all of F1F9’s keyboard shortcuts here . Alternatively, you will find them documented in the workbook itself.

Hiding the keyboard shortcuts

Now you have got the shortcuts working, you may want to hide the F1F9 keyboard shortcuts workbook so that it sits invisible as you work and does not get in the way. Make sure you are looking at the F1F9 keyboard shortcuts workbook and use the standard Excel shortcut Alt W, H to hide it.

If you wish to unhide it again, then try Alt W, U.

Tip: a hidden workbook is still open – it is just you can’t see it. Hiding a workbook is quite different from closing a workbook down.

Opening the F1F9 keyboard shortcuts automatically

You can change your settings in Excel so that the F1F9 keyboard shortcuts workbook opens when you open Excel.

Firstly, save a copy of the F1F9 keyboard shortcuts workbook in a dedicated folder. For example, set up a folder on your desktop called “F1F9 Macros”.

Next, take a copy to the clipboard of the folder’s file path. You will find that by clicking in the formula bar relating to the folder in File Explorer.

Opening the F1F9 keyboard shortcuts automatically

In this instance, the file path is “C:\Users\Andrew\Desktop\F1F9 macros”.

Now move back to Excel and open up Options using Alt F, T. Select the “Advanced” tab and find the menu tab called “At startup, open all files in:”. Paste the contents of the clipboard into the menu box.

Paste the contents of the clipboard into the menu box

Tap “OK” and then come out of Excel all together.

Next time you open Excel, the settings in Excel will prompt it to open up all files that you have stored in your chosen file path. This means that F1F9’s keyboard shortcuts will be available to you when you open up any spreadsheet that you wish to work on.

And if you have saved the F1F9 keyboard shortcuts file in a hidden state then it won’t get in your way.

Tip: only store in your chosen folder those files that you wish to have open every time you open Excel.

Aroop Das
Do you have a better solution than this? I’m curious to know. If you do, or if you have any thoughts on my blog, join the discussion below.If you’d like to receive more information on data visualisation, please sign up to the topic-specific mailing list.
Aroop Das