About Lesson
Moving around worksheet or between cells:
1.Use tab/Enter/arrow keys to move to one adjacent cell.
- Ctrl+arrows to move to end of data contained cells
- ctrl+home to activate first non-blank cell
- ctrl+End to activate last non-blank cell
A group of adjacent cells are called as Range. The range of cells is denoted by the firstcellof range:last cell of range.
selecting range of cells:
- Hold shift, use arrows to select adjacent cells one by one
- hold ctrl+shift, use arrow keys to select entire range of cells containing data.
- type address of range in name box; press enter
- select any cell, press ctrl+A
to select non adjacent cells: hold ctrl, click on each cell
to deselect selection: click or press any arrow key
to select entire row:
click on row number (or) press shift+space
to select entire column:
click on column label (or) press ctrl+space
to select entire sheet: ctrl+A (being in a blank cell)