Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 83 - 2612 Digimind C5
P. 83

    In the previous chapter, we learnt how to open Excel, how to enter data and how to select
                     it and also learnt about working with worksheets. In this chapter, we will learn more about
                     Excel.

                               SELECTING A RANGE OF CELLS

                     Let us learn how to select a range of cells.

                                                                                              To select a row:
                     SELECTING A CELL
                     To select a cell, click on the cell. It will become the active      Short key  Ctrl  +  Shift +

                     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

                     To select a row, place the mouse pointer on the row header of the               Click here to select
                     row to be selected. The mouse pointer will change to an arrow. Now                 entire Column
                     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.

                                                                                                   Editing in Excel 2021  81

| 78 79 80 81 82 83 84 85 86 87 88 |