Worksheet Navigation (Excel )

Active Cell   To move between cells on a worksheet, click any cell or use the arrow keys.    When youmove to a cell, it becomes the active cell. To see a different area of the sheet, use the scroll bars.
       Note that the size of a scroll box indicates the proportional amount of the used area of the sheet that is visible in the window. The position of a scroll box indicates the relative location of the visible area within the worksheet. 

         To Scroll                                       Do This 
  One row up or down                   Click the arrows in the vertical scroll bar. 
  One column left or right               Click the arrows in the horizontal scroll bar. 
  One window up or down             Click above or below the scroll box in the vertical scroll bar. 
  One window left or right              Click to the left or right of the scroll box in thehorizontal scroll 
  A large distance                            Drag the scroll box to the approximate relativeposition. In a 
                                                      very large worksheet, hold down SHIFT while dragging. 

  Selecting Cells and Ranges  

      To select                                         Do This 
1- A single cell                                Click the cell, or press the arrow keys to move to the cell. 
2- A range of cells                           Click the first cell of the range, and then drag to the last cell. 
3- All cells on a worksheet               Click the Select All button. 
4-Nonadjacent cells or cell ranges     Select the first cell or range of cells, and then hold
                                                        down CTRL and select the other cells or ranges.

 5- A large range of cells                    Click the first cell in the range, and then hold down
                                                       SHIFT and click the last cell in the range. You canscroll to  make the last cell visible.

      6-An entire row                                 Click the row heading.

          7- Adjacent rows or columns               Drag across the row or column headings. Or select the first row
                                                               or column; then hold down SHIFT and select the last row or column.   
   8- Nonadjacent rows or columns       Select the first row or column, and then hold down CTRL and        select   the other rows or columns.  


No comments:

Post a Comment