Header Ads



Micro soft Excel Short Keys

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.
[email protected]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+1Displays the Format Cells dialog box.
CTRL+2Applies or removes bold formatting.
CTRL+3Applies or removes italic formatting.
CTRL+4Applies or removes underlining.
CTRL+5Applies or removes strikethrough.
CTRL+6Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
CTRL+7Displays or hides the Standard toolbar.
CTRL+8Displays or hides the outline symbols.
CTRL+9Hides the selected rows.
CTRL+0Hides the selected columns.
CTRL+ASelects 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+BApplies or removes bold formatting.
CTRL+CCopies the selected cells.
CTRL+C followed by another CTRL+C displays the Microsoft Office Clipboard.
CTRL+DUses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
CTRL+FDisplays the Find dialog box.
CTRL+GDisplays the Go To dialog box.
F5 also displays this dialog box.
CTRL+HDisplays the Find and Replace dialog box.
CTRL+IApplies or removes italic formatting.
CTRL+KDisplays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlinkdialog box for selected existing hyperlinks.
CTRL+LDisplays the Create List dialog box.
CTRL+NCreates a new, blank file.
CTRL+ODisplays the Open dialog box to open or find a file.
CTRL+SHIFT+O selects all cells that contain comments.
CTRL+PDisplays the Print dialog box.
CTRL+RUses 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+SSaves the active file with its current file name, location, and file format.
CTRL+UApplies or removes underlining.
CTRL+VInserts 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+WCloses the selected workbook window.
CTRL+XCuts the selected cells.
CTRL+YRepeats the last command or action, if possible.
CTRL+ZUses the Undo command to reverse the last command or to delete the last entry you typed.
CTRL+SHIFT+Zuses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Post a Comment