April 3 2006
Q: I am faster using my keyboard than using a mouse and I frequently create spreadsheets in Excel.  Can you share some keyboard short-cuts that may help me maneuver through the spreadsheets?

A: Here are a few:

CTRL + (any) Arrow key

-Moves you to the next non-blank cell

CTRL + Home

-Moves you to cell A1

CTRL + End

-Moves you to the last cell in your spreadsheet (lower, right hand side)

CTRL + Page Down or Page Up

-Moves to the next (previous) Worksheet

CTRL + BACKSPACE

-Displays the cell your cursor is currently located (handy if you are currently viewing another part of your spreadsheet and need to revert back)

-CTRL + SPACEBAR

-Selects the entire column

-SHIFT + SPACEBAR

-Selects the entire row