This shortcut expands or collapses the formula bar, a useful tool when you're moving about a variety of workspaces and inspecting cells. 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. F4: Repeat the last editĪnother powerful Excel shortcut is making good use of the F4 key. This will prove invaluable for making quick changes. This Excel shortcut will enter cell edit mode with the cursor at the end of the cell. One of the handiest Excel shortcuts can be accessed by simply pressing F2.

Excel shortcut keys pdf 2013