Shortcut Keys of Microsoft Excel
CTRL+( ==> Unhides any hidden rows within the selection.
CTRL+) ==> Unhides any hidden columns within the selection.
CTRL+& ==> Applies the outline border to the selected cells.
CTRL+_ ==> Removes the outline border from the selected cells.
CTRL+~ ==> Applies the General number format.
CTRL+$ ==> Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+% ==> Applies the Percentage format with no decimal places.
CTRL+^ ==> Applies the Exponential number format with two decimal places.
CTRL+# ==> Applies the Date format with the day, month, and year.
CTRL+@ ==> Applies the Time format with the hour and minute, and AM or PM.
CTRL+! ==> Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
CTRL+- ==> Displays the Delete dialog box to delete the selected cells.
CTRL+* ==> Selects the current region around the active cell (the data area enclosed by blank rows and blank columns).
CTRL+: ==> Enters the current time.
CTRL+; ==> Enters the current date.
CTRL+` ==> Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+’ ==> Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+” ==> Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL++ ==> Displays the Insert dialog box to insert blank cells.
CTRL+1 ==> Displays the Format Cells dialog box.
CTRL+2 ==> Applies or removes bold formatting.
CTRL+3 ==> Applies or removes italic formatting.
CTRL+4 ==> Applies or removes underlining.
CTRL+5 ==> Applies or removes strike through.
CTRL+6 ==> Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7 ==> Displays or hides the Standard toolbar.
CTRL+8 ==> Displays or hides the outline symbols.
CTRL+9 ==> Hides the selected rows.
CTRL+0 ==> Hides the selected columns.
CTRL+A ==> Selects the entire worksheet. If the worksheet contains data,
CTRL+A ==> Selects the current region. Pressing
CTRL+A ==> A second time selects the entire worksheet.
CTRL+B ==> Applies or removes bold formatting.
CTRL+C ==> Copies the selected cells.
CTRL+C ==> Followed by another CTRL+C displays the Microsoft Office Clipboard.
CTRL+D ==> Uses the Fill Downcommand to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+F ==> Displays the F in dialog box.
CTRL+G ==> Displays the Go To dialog box.
F5 also displays this dialog box.
CTRL+H ==> Displays the Find and Replace dialog box.
CTRL+I ==> Applies or removes italic formatting.
CTRL+K ==> Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+L ==> Displays the Create List dialog box.
CTRL+N ==> Creates a new, blank file.
CTRL+O ==> Displays the Open dialog box to open or find a file.
CTRL+SHIFT+O ==> Selects all cells that contain comments.
CTRL+P ==> Displays the Print dialog box.
CTRL+R ==> Uses the Fill Rightcommand to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S ==> Saves the active file with its current file name, location, and file format.
CTRL+U ==> Applies or removes underlining.
CTRL+V ==> Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you cut or copied an object, text, or cell contents.
CTRL+W ==> Closes the selected workbook window.
CTRL+X ==> Cuts the selected cells.
CTRL+Y ==> Repeats the last command or action, if possible.
CTRL+Z ==> Uses the Undo command to reverse the last command or to delete the last entry you typed.
CTRL+SHIFT+Z ==> Uses the Undo or Redo command to reverse or restore the last automatic correction when Auto Correct Smart Tags are displayed.
Leave a Comment