If you quickly want to see what cells are referenced in another cell, use this Excel shortcut to see them. This shortcut is especially useful in Excel worksheets that have seemingly endless formulas. CTRL + [: Select all cells directly referenced by formulas in the selection Instead of using your mouse to click on the header, use this shortcut to automatically select the entire column that you are working in. CTRL + Shift + % : Percentage style a number This command styles your cell to a general style number. This shortcut removes the outline border to a selected cell or range. Use this to quickly underline or un-underline a cell or text. Use this to quickly italicize or un-italicize a cell or text. Use this to quickly bold or unbold a cell or text. Plus it makes you feel nice and fuzzy on the inside. This really does pay dividends in the long run. Borders are generally a good idea to use if you want to organize your worksheet and make it appear more professional. Instead of navigating through endless menus, use this Excel shortcut to quickly add borders to the cells you have selected. CTRL + Shift + &: Applies border to cells 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.

Set excel shortcut keys