Microsoft Office Tutorials and References
In Depth Information
Keyboard Shortcuts
CTRL+SHIFT+"
Copies the value from the cell above the active cell into the cell or the Formula Bar. That is, if
you click in a blank cell, this shortcut will copy any value in the cell immediately above it. If
that value is the result of a formula, this shortcut will paste only that value, not the formula.
CTRL+;
Enters the current date as data – not a formula result
CTRL+`
Alternates between displaying cell values and displaying formulas in the worksheet. That is,
this shortcut will display a cell formula onscreen instead of its value. Tap the shortcut a
second time and the value returns. This option is available for the workbook via File
Advanced Show formulas in cells instead of their calculated results.
CTRL+'
Copies a formula from the cell above the active cell into selected cells, or the Formula Bar.
The copied formula cell references change as per relative cell references. You need to select
the source cell along with the destination cells at the same time.
CTRL+1
Displays the Format Cells dialog box.
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, that is, an area of cells populated by data (e.g., a table) – if you click in that region.
Pressing CTRL+A a second time selects the entire worksheet. If you click in a blank area of
the worksheet, CTRL+A will initially select the entire worksheet.
CTRL+B
Applies or removes bold formatting with alternating taps.
CTRL+C
Copies the selected cells.
CTRL+D
Uses the Fill Down command to copy the contents and format of the topmost cell of a
selected range into the cells immediately below.
CTRL+F
Displays the Find and Replace dialog box, with the Find tab selected. This works similarly to
the Find and Replace option in Word. Also available on the Home ribbon Editing button
group Find & Select.
CTRL+SHIFT+F
Opens the Format Cells dialog box with the Font tab selected
CTRL+G
Displays the Go To dialog box, as does F5.
CTRL+H
Displays the Find and Replace dialog box, selecting the Replace tab.
CTRL+I
Applies or removes italic formatting with alternating taps.
CTRL+L
Displays the Create Table dialog box. Equivalent to CTRL+T.
CTRL+N
Creates a new, blank workbook.
CTRL+O
Displays the Open dialog box to open or find a file.
CTRL+P
Displays the Print tab in Microsoft Office Backstage view.
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.
Search JabSto ::




Custom Search