Page 271 - Trackpad IT-402_Class-IX
P. 271

NAVIGATION IN A WORKSHEET

            Given below are some shortcut keys to move the active cell in a worksheet.

                         Key/Keys Combination                                     Explanation

                             ↑
             Arrow keys                                     Moves a single cell in the direction of the arrow key
                         ←   ↓   →

                                  ↑                         Moves  the  cell  to  the  end/beginning  of  the  row/column
             Ctrl + Arrow keys
                              ←   ↓   →                     moving in the direction of the arrow key.

             Home                                           Moves to the first cell of the current row.
             End                                            Moves to the last cell containing the text of the current row.
             Pg Dn                                          Moves one screen down in the worksheet.

             Pg Up                                          Moves one screen up in the worksheet.
             Ctrl + Home                                    Makes A1 the active cell.
             Ctrl + End                                     Makes the last cell on the sheet with data as the active cell.

             F2                                             Enters the active cell into the edit mode.
             Ctrl + F2                                      Opens the Function Wizard.

             Shift + Ctrl + F5                              Moves the cursor to the Name Box of the formula bar.



                                    Find out the address of the:
                     uiz Bee        •  first cell of a worksheet.                •  last column name.

                                    •  last cell of a worksheet.                •  first row number.








                          Subject: To rename a sheet

                          A sheet can easily be renamed by using the given steps:
                          1.  Double click on the sheet tab. It will open the Rename Sheet dialog box.
                          2.  Delete the existing sheet name and type a new name.
                          3.  Press the Enter key.






                    ENTERING DATA

            The data is always entered in an active cell. You can make the cell active by selecting it. Follow the given steps to enter
            data in a spreadsheet.
            Step 1:  Select a cell.

            Step 2:  Type the data in the cell.

                                                                                          Electronic Spreadsheet  271
   266   267   268   269   270   271   272   273   274   275   276