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. The keyboard shortcut Shift+Space selects the entire row containing the active cell.One of the handiest Excel shortcuts can be accessed by simply pressing F2.In Microsoft Excel and other spreadsheet programs, pressing Ctrl+Space selects the entire column containing the active cell.To use the keyboard shortcut Ctrl+Space, press and hold either Ctrl key on the keyboard and while continuing to hold, press the spacebar key with either hand.Ĭtrl+Space in Excel and other spreadsheet programs.On Apple computers, the shortcut to save may also be Command key+Spacebar keys.

Ms excel shortcut keys pdf 2020