This command switches worksheet tabs to the left, obviously.īy using this Excel shortcut you can quickly switch between displaying a cell's formula and its values in a snap. CTRL + PgDn: Go to the previous worksheet This command switches worksheet tabs to the right. For example, the most common slip-up is missing the O, which may paste the last thing saved on Excel's clipboard. Then type I to autofit the column width.īe careful, however, as if you are typing too fast you may accidentally skip one of the keys. Then type O to select the format menu (while still holding Alt). First press Alt + H to navigate to the home tab. This shortcut functions as more of a sequence. ALT + H + O + I: Autosize columns Source: BigOakFlickr/Flickr If you need to write a large paragraph inside a worksheet, knowing this function is essential. It essentially functions as a line break inside of a cell. This shortcut is handy for those of us who need to put a lot of data into one cell. ALT + Enter : Start a new line in the same cell Make sure you include a spare column on the right and a spare row on the bottom for the summation data. If you have a block of data and you want to add all of the columns and the rows, using this command will Autosum the data and put all of the equations in one swoop.

The SUM() function is quite possibly one of Excel's most useful formulas. 7: ALT + = : Automatically insert the SUM() function Using CTRL + F1 will toggle the display of the Ribbon. These are called KeyTips which will help you navigate the ribbons using only your keyboard. Pressing the ALT key makes small letters appear on the toolbar ribbons. ALT: Access the ribbon for formulas Source: Erik Eckel/Flickr When you have data selected and press F11, a default chart will automatically appear with the selected data inside. Using F11 is a handy and quick way to create a new chart without having to navigate through Excel's native toolbars. This shortcut opens the format cells dialog box so that you can quickly make changes to the appearance of your cells. 4: Ctrl + 1: Open the format cells dialog box A handy Excel shortcut not to be sniffed at. This works for all of them even those that have not changed since the last calculation. Using this Excel shortcut force calculates all worksheets that have open workbooks. CTRL + ALT + F9: Calculates all worksheets If you want to repaste something again or repeat a formula insert, this key will save you a ton of time. This will repeat your last action or edit. Another powerful Excel shortcut is making good use of the F4 key.

Set excel shortcut keys