Page 188 - CA_165_V2.0_C9_Flipbook
P. 188
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
Multiple Columns Click on the first column and drag till the required column
Whole Spreadsheet Click on the uppermost left corner of the spreadsheet
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+Page Down
One Screen to the Left Press Alt+Page Up
From any Cell to A1 Press Ctrl+Home
To the Next sheet Press Ctrl+Page Down
To the Previous sheet Press Ctrl+Page Up
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 Spreadsheet Press Ctrl+A
To select a Range of Cells Press Shift and select the range with arrow keys
(Columns/Rows)
Other Shortcut Keys
The other shortcut keys required to work in Calc are:
Purpose Action Required
To Open a New Spreadsheet Press Ctrl+N
To Save an existing Spreadsheet Press Ctrl+S
To Save a New Spreadsheet Press Ctrl+Shift+S
To Close a Spreadsheet Press Ctrl+W
186 Touchpad Computer Applications (Ver. 2.0)-IX

