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