F2 Add or edit a cell comment. Selects the first command on the menu when a menu or submenu is visible. Ctrl+2 Applies or removes bold formatting. However, if the keyboard is what you prefer to use, then here is how you can resize a window using the keyboard! Ctrl+F2 displays the print preview area on the Print tab in the Backstage view. I suggest you to try perform System File Checker sfc scan and check if it helps.
See our page for a full listing of what function keys do with all other programs. Right arrow key Move to the edge of the current data region in a worksheet. Ctrl+Alt+V displays the Paste Special dialog box. Ctrl+Shift+Page Down Select the current and previous sheet in a workbook. Function keys Key Description F1 Displays the Excel Help task pane. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu.
Or, if editing is turned off for the cell, move the insertion point into the formula bar. 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+D Apply the General number format. Press a second time to select the current region and its summary rows. Alt+N Open the Page Layout tab and work with themes, page setup, scale, and alignment.
Windows key + PrtScn Capture a screenshot and save in Screenshots folder. Most of the old Alt+ menu shortcuts still work, too. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. Pressing Ctrl+A a second time selects the entire worksheet. Ctrl + W only closes the current files you're working on but leaves the program open.
Other useful shortcuts Key Description Alt Displays the Key Tips new shortcuts on the Ribbon. Also clears the content of the active cell. Ctrl + Alt +Tab View open apps Ctrl + C Copy selected items to clipboard. To print this topic, press Ctrl+P. It seems that, some of the system files got corrupted. Ctrl+Enter fills the selected cell range with the current entry. In Windows 8, this opens or hides the.
Snap a Windows App to the sides of the screen. Ctrl+T Displays the Create Table dialog box. Windows key + R Open Run dialog box. When working with images, use local storage rather than external sources like network shares or removable drives. Use the arrow keys to move the window, and when finished press Enter, or Esc to cancel. Esc Keyboard shortcuts for formatting cells To do this Press Open the Format Cells dialog box.
Ctrl+B or Ctrl+2 Underline text or remove underline. To complete this guide, get the recommended downloads in this section from. Ctrl+Alt+5, then the Tab key repeatedly Exit the floating shape navigation and return to the normal navigation. Shift+Arrow key Extend the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. F1 Activates help for current open application.
Page Up Moves one screen up in a worksheet. Ctrl+Shift+Spacebar Extend the selection of cells to the beginning of the worksheet. Tab Open the list of validation choices on a cell that has data validation option applied to it. Ctrl+End Extend the selection of cells to the last used cell on the worksheet lower-right corner. Ctrl+9 Hides the selected rows. Alt+F8 Open the Microsoft Visual Basic For Applications Editor.
Ctrl+Alt+Shift+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Available only if names have been defined in the workbook Formulas tab, Defined Names group, Define Name. If the worksheet contains data, Ctrl+A selects the current region. In cell editing mode, it deletes the character to the right of the insertion point. F9 Calculates all worksheets in all open workbooks. Although memorizing which shortcuts do which functions can be a little daunting at first, it's important to remember not everyone needs to know every shortcut.