You might already know that pressing Ctrl while selecting
is a common way to select discontinuous cells, but this method occupies
both of your hands. This section provides you with a comfortable way
to select discontinuous cells.
Microsoft® Excel
2003
To select discontinuous cells, do the following steps:
- Before you select the cells, press Shift+F8 to enter the Add selection
mode. You can see that Add is displayed on the status bar at the bottom
of the window.
- Select the cells as you want.
To quit the Add selection mode, press Shift+F8 again.
IBM® Lotus® Symphony™ Spreadsheets
To
select discontinuous cells, do the following steps:
- Before you select the cells, press Shift+F8 to change the selection
mode to Addition on the status bar.
- Select the cells as you want.
To quit the Addition mode, press
Shift+F8 again.