Microsoft excel 2016 shortcut keys and formulas pdf

CTRL+& Applies the outline border to the selected cells. CTRL+) Unhides any hidden columns within the selection. CTRL+( Unhides any hidden rows within the selection. CTRL+8 Displays or hides the outline symbols. CTRL+7 Displays or hides the Standard toolbar. CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects. CTRL+3 Applies or removes italic formatting. CTRL+2 Applies or removes bold formatting. CTRL+1 Displays the Format Cells dialog box. CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry you typed. CTRL+Y Repeats the last command or action, if possible. CTRL+W Closes the selected workbook window. Available only after you cut or copied an object, text, or cell contents. CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. CTRL+S Saves the active file with its current file name, location, and file format. CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. CTRL+O Displays the Open dialog box to open or find a file. CTRL+L Displays the Create List dialog box. CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. CTRL+I Applies or removes italic formatting.

CTRL+H Displays the Find and Replace dialog box. CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. CTRL+B Applies or removes bold formatting. Excel Shortcut Key Excel Shortcut Keys Shortcut Key Action CTRL+A Selects the entire worksheet.

Microsoft excel 2016 shortcut keys and formulas pdf