Hello and a very Happy New Year from the Excel Tip of the Week!
As a reminder, all the TOTW posts are classified with a complexity grading in line with ICAEW's Spreadsheet Competency Framework. We're kicking off 2019 with a Basic User level post in which we're covering the various uses of the function keys in Excel. All of our posts are written with Excel for Windows in mind, but for this post especially so!
What each function key can do
Some of the functionality we talk about here is universal to all Windows applications, and a lot are specific to Excel. This is a selection - some of the more particular or useless shortcuts are omitted.
Nobody regularly needs to use all of these, but it's worth knowing what options are out there!
Previous post - Revisiting form controlsTOTW index Next post - VBA case study: Organising collections and fair sharing
This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.
A variation on this shortcut is to double clock on a cell to jump to the precedent cells (or first cross-sheet cell reference) within a formula. The default setting in Excel is that a double click on a cell begins editing the formula. However, this can be changed to jump to precedents on the same sheet (or first cross-sheet cell reference) by unticking Excel Options | Advanced | Editing options | Allow editing directly in cells.
I use the shortcut Ctrl + [ all the time - it's almost subconscious, like breathing in Excel.
This can be done with Ctrl and [. You can then go back by pressing F5 and then Enter.
I've always hated Function keys and much preferred to use the menus. However there is one key I would love to remember which is "Jump to the cell reference in this formula". Can anyone tell me what it is?? Please!