Page 176 - CA 165 ver 1.0 Class 9
P. 176
Using Mouse
This is how we can make the following selections using mouse:
To Select Action Required
Single Cell Click on the specified cell
Multiple Cell Drag the mouse over the range of cells
Row Click on the row heading
Column Click on the column heading
Multiple Rows Click on the first row number and drag till the required row
Click on the first letter of a column and drag till the required
Multiple Columns
column
Whole Worksheet Click on the uppermost left corner of the worksheet
Using Keyboard
This is how we can make the following moves/selections using keyboard:
To Move the Cell Pointer/Select Action Required
To move Right Press Right arrow or Tab
To move Left Press Left arrow or Shift+Tab
To move Above Press Up arrow or Shift+Enter
To move Below Press Down arrow or Enter
One Screen to the Right Press Alt+Pg Dn
One Screen to the Left Press Alt+Pg Up
From any Cell to A1 Press Ctrl+Home
To the Next sheet Press Ctrl+PgDn
To the Previous sheet Press Ctrl+PgUp
To the previous opened workbook Press Ctrl+Shift+Tab or Ctrl+Shift+F6
To select a Row Activate a cell in the row and press Shift+Spacebar
Activate a cell in the column and press
To select a Column
Ctrl+Shift+Spacebar
To select entire Worksheet Press Ctrl+A
To select a Range of Cells Press Shift and select the range with arrow key
(Columns/Rows)
174 Touchpad Computer Applications-IX

