Ms-Excel 2007
About Lesson

Moving around worksheet or between cells:

1.Use tab/Enter/arrow keys to move to one adjacent cell.

  1. Ctrl+arrows to move to end of data contained cells
  2. ctrl+home to activate first non-blank cell
  3. 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:

  1. Hold shift, use arrows to select adjacent cells one by one
  2. hold ctrl+shift, use arrow keys to select entire range of cells containing data.
  3. type address of range in name box; press enter
  4. 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)

You cannot copy content of this page