Page 218 - IT_Play_V1.0 Class9
P. 218
MOVING IN A SHEET
In spreadsheet, commands or data have to be entered with the help of input devices like mouse and keyboard
in different cells of the spreadsheet. The following are some of the shortcuts for different actions in the
spreadsheet.
Using Mouse
To Select Action Required
Single Cell Click on the specified cell
Multiple Cell Drag the mouse over the range of cells
A Row Click on the row heading
A 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 the Keyboard
To Move the Cell Pointer Action Required
To move right Press the Right arrow or Tab
To move left Press the Left arrow or Shift +Tab
To move above Press the Up arrow or Shift + Enter
To move below Press the Down arrow or Enter
To Scroll Down Press Page Down
One screen to the right Press Alt + Page Down
To Scroll Up Press Page Up
One screen to the left Press Alt + Page Up
From any cell to column A Press Home
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 last cell Press Ctrl + End
To select a row Activate a cell in the row and press Shift+Spacebar
To select a column Activate a cell in the column and press Ctrl +Spacebar
To select the entire spreadsheet Press Ctrl + A
To select a range of cells (Columns/Rows) Press Shift and select the range with the arrow keys
216 Information Technology Play (Ver 1.0)-IX

