Microsoft Office Tutorials and References
In Depth Information
Other shortcut keys
F11
Creates a chart of the data in the current range in a separate Chart sheet.
SHIFT+F11 inserts a new worksheet.
F12
Displays the Save As dialog box.
Other shortcut keys
ARROW KEYS
Moves one cell up, down, left, or right in a worksheet.
CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells
that contains data and that is bounded by empty cells or datasheet borders) in a worksheet.
SHIFT+ARROW KEY extends the selection of cells by one cell.
CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same
column or row as the active cell, or if the next cell is blank, extends the selection to the next
nonblank cell.
LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the ribbon is
selected. When a submenu is open or selected, these arrow keys switch between the main
menu and the submenu. When a ribbon tab is selected, these keys navigate the tab buttons.
DOWN ARROW or UP ARROW selects the next or previous command when a menu or
submenu is open. When a ribbon tab is selected, these keys navigate up or down the tab
group.
In a dialog box, arrow keys move between options in an open drop-down list, or between
options in a group of options.
DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE
Deletes one character to the left in the Formula Bar. If you select the cell’s contents in the
Formula Bar, Backspace deletes all those contents, just as selecting a word in Word and
pressing Backspace deletes the entire word.
In cell editing mode, it deletes the character to the left of the insertion point – as in Word.
DELETE
Removes the cell contents (data and formulas) from selected cells without affecting cell
formats or comments.
In cell editing mode, it deletes the character to the right of the insertion point – as in Word..
 
Search JabSto ::




Custom Search