Sunday, May 13, 2012

Useful Shortcut Keys

Here are some shortcut keys that I frequently use.

Ctl+ Arrow keys
Select a cell in a range of data
The Ctl key + the down Arrow key will take you from the active cell to the last populated cell in the column
The Ctl key + the up Arrow key will take you from the active cell to the first populated cell in the column
The Ctl key + the right Arrow key will take you from the active cell to the last populated cell in the row
The Ctl key + the left Arrow key will take you from the active cell to the first populated cell in the row

Ctl + Shift + the Arrow keys as above will select all cells from active cell to the last populated cell.  The selection of a range of cells allows you to copy, cut, format etc.

Ctl + C copies the active cell

Ctl + V pastes whatever has been copied to the active cell

Ctl + Z  undo last action

Ctl + A select all cell in current region

Ctl + F find


No comments:

Post a Comment