Microsoft Office Tutorials and References
In Depth Information
Function keys
CTRL+U
Applies or removes underlining with alternating taps.
CTRL+V
The classic Paste command. 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+ALT+V
Displays the Paste Special dialog box, enabling you to paste only the results of a copied
formula, by clicking the Values option in the dialog box. If, for example, a formula in cell A17
states =SUM(A2:A13) and yields 3224, Paste Special will return only the value 3224 in the
destination cell. It will not copy the formula. This option is also available via the Paste button
in the Home ribbon and on the Paste shortcut menu.
CTRL+W
Closes the selected workbook window.
CTRL+X
Cuts the selected cells.
CTRL+Y
Redo; that is, it undoes the last command you’ve undone via Undo. But it also repeats any
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.
Successive CTRL+Zs continue to undo the immediately previous command.
Function keys
F1
Displays the Excel Help task pane.
CTRL+F1 displays or hides the ribbon.
ALT+F1 creates a chart of the data in a current range in which you’ve clicked, on the
worksheet contaning the data.
ALT+SHIFT+F1 inserts a new worksheet.
F2
Edits the active cell and positions the insertion point at the end of the cell contents. It also
moves the insertion point into the Formula Bar when editing in a cell is turned off. This
keystroke draws a temporary border around the cells that contribute to any formula in the
cell you’re editing. Thus tapping F2 on a cell containing =AVERAGE(A6:A10) will trace a
border around cells A6:A10. An easy way to identity cell relationships.
SHIFT+F2 adds or edits a cell comment.
CTRL+F2 displays the print preview area on the Print tab in the Backstage view, as does
CTRL-P.
F3
Displays the Paste Name dialog box. Available only if there are existing names in the
workbook.
SHIFT+F3 displays the Insert Function dialog box.
F4
Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window, as does CTRL-W.
ALT+F4 closes Excel. As usual you’ll will be prompted to save your changes should you not
have already done so.
 
Search JabSto ::




Custom Search