Selecting Ranges of Cells

[ LiB ]

Selecting Ranges of Cells

You can use your mouse to select a range of cells for editing, or you can use these keyboard shortcuts.

To select this

Do this

The entire worksheet

Press Ctrl+A

The current selection by one cell

Press Shift+arrow key

The current selection to the end of a row

Press Ctrl+Shift+right arrow

The current selection to the end of a column

Press Ctrl+Shift+down arrow

The current selection to the last used worksheet cell

Press Ctrl+Shift+End

The current selection to cell A1

Press Ctrl+Shift+Home

An entire column

Press Ctrl+Spacebar

An entire row

Press Shift+Spacebar

The current selection to the beginning of a row

Press Shift+Home


[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net