CTRL Combination Shortcut Keys
CTRL combination shortcut keys of Microsoft Excel 2007
CTRL combination shortcut keys of Microsoft Excel 2007
Key
|
Description
|
CTRL+SHIFT+(
|
Unhides any hidden rows within the
selection.
|
CTRL+SHIFT+)
|
Unhides any hidden columns within
the selection.
|
CTRL+SHIFT+&
|
Applies the outline border to the
selected cells.
|
CTRL+SHIFT_
|
Removes the outline border from
the selected cells.
|
CTRL+SHIFT+~
|
Applies the General number format.
|
CTRL+SHIFT+$
|
Applies the Currency format with
two decimal places (negative numbers in parentheses).
|
CTRL+SHIFT+%
|
Applies the Percentage format with
no decimal places.
|
CTRL+SHIFT+^
|
Applies the Exponential number
format with two decimal places.
|
CTRL+SHIFT+#
|
Applies the Date format with the
day, month, and year.
|
CTRL+SHIFT+@
|
Applies the Time format with the
hour and minute, and AM or PM.
|
CTRL+SHIFT+!
|
Applies the Number format with two
decimal places, thousands separator, and minus sign (-) for negative values.
|
CTRL+SHIFT+*
|
Selects the current region around
the active cell (the data area enclosed by blank rows and blank columns).
In a PivotTable, it selects the entire PivotTable report.
|
CTRL+SHIFT+:
|
Enters the current time.
|
CTRL+SHIFT+"
|
Copies the value from the cell
above the active cell into the cell or the Formula Bar.
|
CTRL+SHIFT+Plus (+)
|
Displays the Insert dialog
box to insert blank cells.
|
CTRL+Minus (-)
|
Displays the Delete dialog
box to delete the selected cells.
|
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+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 strikethrough.
|
CTRL+6
|
Alternates between hiding objects,
displaying objects, and displaying placeholders for objects.
|
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 current region and its
summary rows. Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function
name in a formula, displays the Function Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses
when the insertion point is to the right of a function name in a formula.
|
CTRL+B
|
Applies or removes bold
formatting.
|
CTRL+C
|
Copies the selected cells.
CTRL+C followed by another CTRL+C displays the Clipboard.
|
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+F
|
Displays the Find and Replace
dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats
the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with
the Font tab selected.
|
CTRL+G
|
Displays the Go To dialog
box.
F5 also displays this dialog box.
|
CTRL+H
|
Displays the Find and Replace
dialog box, with the Replace tab selected.
|
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+N
|
Creates a new, blank workbook.
|
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+SHIFT+P opens the Format Cells dialog box with
the Font tab selected.
|
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+S
|
Saves the active file with its
current file name, location, and file format.
|
CTRL+T
|
Displays the Create Table
dialog box.
|
CTRL+U
|
Applies or removes underlining.
CTRL+SHIFT+U switches between expanding and collapsing of
the formula bar.
|
CTRL+V
|
Inserts the contents of the
Clipboard at the insertion point and replaces any selection. Available only
after you have 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 that you typed.
CTRL+SHIFT+Z uses the Undo or Redo command
to reverse or restore the last automatic correction when AutoCorrect Smart
Tags are displayed.
|
0 comments :
Post a Comment