Handy hints for using Excel

View as Word document

Selecting more than one cell

To select a block of cells you can drag across it with the mouse. However, with a large block of cells, it easier to click on the one corner of the block, then scroll to the opposite corner, and hold down Shift while you click on it.

To select multiple blocks of cells, select the first block, then hold down Ctrl while you select the next block, and so on.

You can now apply formats and other features to all the cells at once.

Entering the same information into several cells at once

First select all the cells as above.

Type the required entry into the space at the top of the Excel window (the formula bar).

Hold down the Ctrl key while you press the Enter key.

Your typing will be entered into all the highlighted cells at once.

Changing column widths so all the information is visible

Drag the dividing line between the column heading (A, B, C, etc.) for the chosen column and the one to the right of it.

To do this for several columns at once, first highlight all the columns by dragging over the column headings.