Page 32 - 2611_SmartGPT Pro V(5.0) C-5
P. 32

Tick ( ) if you know this.

                      ▶   Quick Access Toolbar is present at the bottom of the Excel window.

                      ▶   We can add a new worksheet in an Excel workbook.






                            SELECTING A RANGE OF CELLS

                  Let us learn how to select a range of cells.
                                                                                           To select a row:
                  SELECTING A CELL                                                            Ctrl   +   Shift +

                  To select a cell, click on the cell. It will become the active      Short key
                  cell and a green border appears around it. You can also
                  use the arrow keys to move to change the active cell.                       Left/Right Arrow


                  SELECTING A ROW







                          Click here to select an entire row
                                                                                                   Click here to select
                  To select a row, place the mouse pointer on the row header of the                  entire Column
                  row to be selected. The mouse pointer will change to an arrow. Now
                  click on the row header and the entire row gets selected.


                  SELECTING A COLUMN
                  To select a column, place the mouse pointer on the column header
                  of the column to be selected. The mouse pointer will change to an

                  arrow.  Now  click  on the column header, the entire  column gets
                  selected.
                  Or

                  Press Ctrl + Shift + Up/Down Arrow key on the keyboard.


                  RANGE OF CELLS
                  We  might  want  to  select  more  than one  cell at  a time  to
                  perform a certain task. When we select more than one cell
                  at a time, these contiguous (adjoining/connected) cells form
                  a range.






                   30   Computer Science (V5.0)-V
   27   28   29   30   31   32   33   34   35   36   37