Page 37 - Computer Class 07
P. 37

Move  Up  or  Down  One  Page  at  a  Time  :

                                                            Use the page up key on your keyboard to move
                                                            up one page at a time. Use the page down key
                                                            on your keyboard to move down one page at a

                                                            time.




             Go to : The F5 function key is the “Go To” key.

             When you press the F5 key, the Go To dialog box
             opens and prompts you for the cell to which you
             want to go. Type the cell address in the Reference

             field,  click  OK,  and  Excel  jumps  to  that  cell.  For
             example,  if  you  want  to  go  to  cell  A5,  press  F5,
             type A5 in the Reference field, and then press OK.




                                               Name Box : The name box is located on the far left side
                                               of the formula bar. You can use it to go to a specific cell.
                                               Just type the cell you want to go to and then press Enter.

                                               For example, if you want to go to cell B4, type B4 in the
                                               Name box and then press Enter.





                       shortcut



                                                           Shortcut Keys


                    Ctrl + Home                       Moves to the beginning of the worksheet cell A1

                    Ctrl + End                        Moves to the farthest used cell in the worksheet


                    Home                              Moves to the first cell in the current row

                    Ctrl + Page Up                    Scrolls one screen to the right


                    Ctrl + Page Down                  Scrolls one screen to the left

                    Ctrl + G                          Opens the Go To dialog box






                                                                                    Computer-7              37
   32   33   34   35   36   37   38   39   40   41   42