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
   213   214   215   216   217   218   219   220   221   222   223