Select cells or chart items by using shortcut keys

Select cells, columns, or rows in datasheets by using shortcut keys

Press

To

CTRL+SPACEBAR

Select the entire column

SHIFT+SPACEBAR

Select the entire row

CTRL+A

Select the entire datasheet

F8

Turn extend mode on or off

SHIFT+ arrow key

Extend the selection by one cell

CTRL+SHIFT+ arrow key

Extend the selection to the last nonblank cell in the same column or row of the active cell

SHIFT+HOME

Extend the selection to the beginning of the row

CTRL+SHIFT+HOME

Extend the selection to the upper left corner cell of the datasheet

CTRL+SHIFT+END

Extend the selection to the last cell used in the datasheet (lower-right corner)

SHIFT+PAGE DOWN

Extend the selection down one screen

SHIFT+PAGE UP

Extend the selection up one screen

SHIFT+BACKSPACE

If multiple cells are selected, select only the active cell


Select chart items by using shortcut keys

Press

To

DOWN ARROW

Select the previous group of items

UP ARROW

Select the next group of items

RIGHT ARROW

Select the next item within the group

LEFT ARROW

Select the previous item within the group


Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×