Two posts into our run down of Microsoft Excel keyboard shortcuts and we’re getting stuck to the nitty gritty of functions, so now you have your navigation keyboard shortcuts and formatting keyboard shortcuts mastered you are prepared to take on some of Excel’s more specialised functionality and more advanced formatting.
Using these key combinations you will be able to quickly summon functions which will hopefully be able to use to formulate, tabulate and graphically represent your data to give it meaning and context.
|Possibly the most important button for time saving purposes. Pressing F10 toggles the key tips on and off, making it possible to navigate through nearly all of Excel all through using keyboard keys.|
|+||Acts the same as right clicking on a mouse, bringing up the shortcut menu, without using the mouse!|
|Feeling stuck? Then hit to bring up the help menu.|
|Press this while selecting a cell to be able to edit the cell contents as if in the formula bar.|
|+||Press these two buttons together to bring up the Insert Function box, complete with function search feature. Using these functions you can quickly and easily set up formulae within a cell.|
|+||Write a comment for the cell; a great feature for shared projects.|
|+||Brings up the Macro control panel. Read below* to find out more about macros and how they can help cut your spreadsheet work time.|
|+||This brings up the more advanced macro creator, where you create macros using VBA (Visual Basic for Applications) in the Microsoft Visual Basic Editor.|
*Macros allow you to create a set of instructions which can then be set up to be triggered by a key press. For more information on macros be sure to have a read of our Time Saving Tips for Excel article.
|+||Shows and hides the top navigation bar, or Ribbon.|
|This repeats the last action made.|
|Brings up the Go To menu, allowing you to easily move around your worksheet to relevant cells. Great for large spreadsheets!|
|Run a spell check on your worksheet.|
|Once pressed you can extend your cell selection from the cell you currently have selected to wherever you click on next.|
|Refreshes all formulae in all worksheet, so you can update results|
|Automatically creates a chart for any data selected. The chart can then be edited in the design panel in the Ribbon at the top of the screen.|
And now for some extra formatting options you may not know about.
|+ +||Makes selected cell’s formatting currency|
|+ +||Changes selected cell’s formatting to percentage|
|+ +||Changes selected cell’s formatting to time, using hours, minutes, AM or PM.|
|+ +||Puts a boarder around the currently selected cell.|
To learn more ways to make use of this fantastic program why not look into taking part in one of our great Excel Training Courses, available for all levels.