Ctrl + A Selects the Entire Worksheet
Ctrl + B Applies or removes bod formatting
Ctrl + C Copies the Selected Cells
Ctrl + D Uses the Fill Down command to copy
the contents and format of the topmost
Ctrl + F Displays the find Dialog Box.
Ctrl + G Displays the Go to dialog box.
Ctrl + H Displays the find and replace the
dialog box
Ctrl + I Applies and removes italic formatting
Ctrl + K Displays the insert Hyperlink
Ctrl + L Displays
the create list dialogue box
Ctrl + N Creates a new, blank file
Ctrl + O Displays the Open dialog box to open
or find a file.
Ctrl + P Displays the Print Dialog Box.
Ctrl + R Uses the fill right command to copy
the contents and format of the leftmost
Ctrl + S Saves the active file with its
current file name, location and file format.
Ctrl + U Applies or removes underling.
Ctrl + V Paste the contents of the clipboard at
the insertion point and replaces any selection
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.
Ctrl + ` Alternate between displaying cell
values and formulas
Ctrl + 1 Displays the Format Cells dialogue
box
Ctrl + 2 Applies or removes Bold formatting
Ctrl + 3 Applices or removes Italic
Formatting
Ctrl + 4 Applies or Removes Underling.
Ctrl + 5 Applies or Removes Strikethrough.
Ctrl + 6 Alternates
between hiding objects, displaying Objects, and displaying place holders 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 + \ In a selected Row, select the cells
that don’t match the value in the active cell.
Ctrl + [ Select cells that contain formulas
that directly reference the active cell.
Ctrl + ; Enter the date
Ctrl + ‘ Copies a formula from the cell
above the active cell into the cell or the Formula Bar.
Ctrl + / Select the array containing the
active cell.
CTRL + SHIFT KEYS
Ctrl + Shift + A When the insertion point is to the right of a function name
in a formula, insert the argument names and parentheses.
Ctrl
+ Shift + O Select all cells
that contain comments
Ctrl + Shift + Z When the auto Correct Smart tags is displayed, undo or
redo the last automatic correction.
Ctrl + Shift + ! Apply the number format with two decimal places,
thousands separator, and mines for negative values.
Ctrl + Shift + @ Apply the Time format with the hour and minute.
Ctrl + Shift + # Apply the Date format with the Day, Month & Year.
Ctrl + Shift + $ Apply the currency format with two decimal places.
Ctrl + Shift + % Apply the Percentage format with 0 decimal Places.
Ctrl + Shift + ^ Apply the Exponential Number format with two decimal places.
Ctrl + Shift + & Apply the outline border to the
selected cells.
Ctrl + Shift + * Select the current region around the active cells.
Ctrl + Shift + ( Unhide any hidden rows within the selection.
Ctrl + Shift + ) Unhide any hidden Columns within the selection.
Ctrl + Shift + _ Remove the outline border from the selected cells.
Ctrl + Shift + + Insert Blank cells.
Ctrl + Shift + | In a selected column, select the cells that don’t match
the value in the active cell.
Ctrl + Shift + { Select all cells directly or indirectly referenced by
formulas in the selection.
Ctrl + Shift + : Enter the time
Ctrl + Shift + “ Copy the value from the cell above the active cell into
the cell or the formula bar.
Comments
Post a Comment