F11 Creates a from selected data. This is a free template for download, and you can easily modify it to fit your needs. Ctrl+2 Applies or removes bold formatting. Ctrl+F6 switches to the next workbook window when more than one workbook window is open. In this article, I will share the complete list of Microsoft Excel shortcut keys.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. Ctrl+H Displays the Find and Replace dialog box, with the Replace tab selected. In a worksheet that has been split View menu, Manage This Window, Freeze Panes, Split Window command , F6 includes the split panes when switching between panes and the Ribbon area. Ctrl+~ Switch between showing Excel formulas or their values in cells. Alt+F1 Create a chart of the data in the current range in a separate Chart sheet. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Function keys Key Description F1 Displays the Microsoft Office Excel Help task pane. Ctrl+1 Changes the format of the selected cells. Ctrl+Home Move one screen down in a worksheet. Ctrl+ b or ctrl+ 2 Apply or remove bold formatting. Enter Move the cursor to the end of the text when in the formula bar.
If the cursor is in the formula bar, Ctrl+Shift+End selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar. F4 Repeats the last command or action, if possible. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. Ctrl+Page Up moves to the previous sheet in a workbook. Shift+ F3 Displays the Insert Function dialog box.
Ctrl+G Displays the Go To dialog box. To print this topic, press Ctrl+P. Ctrl+ T Displays the Create Table dialog box. Shift+Page Up In a single column, highlights all cells above that are selected. Ctrl+8 Displays or hides the outline symbols. Available only if names have been defined in the workbook Formulas tab, Defined Names group, Define Name.
Opens a selected menu press F10 to activate the menu bar or performs the action for a selected command. Ctrl+ Backspace Delete one word to the left. Shift+F2 adds or edits a cell comment. Moves to the next option or option group in a dialog box. Ctrl+Alt+5, then the Tab key repeatedly Exit the floating shape navigation and return to the normal navigation. Closes an open menu or submenu, dialog box, or message window.
F2 Edits the active cell and positions the insertion point at the end of the cell contents. Ctrl+F4 closes the selected workbook window. Shift+Tab moves to the previous cell in a worksheet or the previous option in a dialog box. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel.
In cell editing mode, it deletes the character to the right of the insertion point. Pressing Ctrl+Shift+Spacebar a third time selects the entire worksheet. Ctrl+ F6 Switches to the next workbook window when more than one workbook window is open. Available only after you have cut or copied an object, text, or cell contents. Some Example of shortcuts is as follow arrow keys shift spacebar press ctrl alt-shift.