For example, a spreadsheet may show several students with Unit scores. The total scores are in the last column.

Fig. 1

To hide columns B to E inclusive, follow these steps:

• Select columns B to E inclusive with the mouse
• Press Crtl 0 (Zero) on the keyboard.

The result looks like this:

Fig 2.

After viewing the Totals beside the names, you can unhide the columns as follows:

• Select columns A to F inclusive with the mouse
• Press Crtl Shift 0 (Zero) on the keyboard

If you wish to hide rows instead of columns, just do the following:

• Select the rows you wish to hide with the mouse
• Press Crtl 9 on the keyboard

If you wish to unhide the hidden rows, select the rows you wish to unhide, and press Ctrl Shift 9 on the keyboard