After the popularity of our previous Microsoft Excel shortcut tutorial post we have decided to follow it up so you can be introduced to using keys for performing formatting. Hopefully you are now using your mouse far less after using our navigation shortcut guide. If not, be sure to have a run through of it first.
Many of these shortcuts can be used across many programs within the Microsoft Office suite, so they can be invaluable to learn in order to speed up your regular day to day tasks.
|+||Press these buttons together while selecting a cell to open the Format cells dialogue box|
|+||Select a cell and press together to bold the contents|
|+||Press together to make contents of selected cell(s) be formatted with italics.|
|+||This will underline the contents of a cell(s). Pressing on content that is already underlined will remove the formatting|
|+ +||Press these three keys together once you have selected cells to draw a boarder around them. Replace the for a _ (underscore) to remove formatting|
|+||Press these together on a cell to view the Style pop up box|
|+ +||Brings up the Format Cells pop up window. From here you can control all of the cell’s formatting and through pressing and the directional arrow buttons you can navigate around without having to resort to using your mouse|
|+||Automatically enter today’s date into the selected cell|
|+ +||Automatically enter the current time into the selected cell. Replace the with to automatically format the cell for date and time|
|+||Select everything in the worksheet|
|+||If used below a cell with a formula in it this function will copy the formula into the selected cell|
|+ +||Brings up the Insert Cells dialogue box. From here you can shift existing cells around to fit in your new cells|
|+||The all important undo command, great help for correcting an error|
|+ +||Apply the cell you currently have selected with the Currency Format|
|+ +||Make the number in the cell selected be formatted as an Exponential number|
|+ +||Make the number in the cell selected to be formatted as a percentage|
There are still plenty more short cuts to discover and make use of. Once you start using keyboard shortcuts more often you will notice a change in your overall user experience of Excel, making it possible to use the program for small tasks you otherwise might have thought about doing in an easier but less efficient or manageable way.
If you would really like to push your Microsoft Excel keyboard shortcut skills then you should take a look at Veodin KeyRocket; a small program that sits in the background and gives you prompts and reminders of shortcuts you could have used instead of using your mouse. It also tracks your progress, so you can measure how close you are getting to becoming an ultimate Excel Poweruser!