Page 9 - KEC Khaitan C6 Flipbook
P. 9

A1
                 EDITING IN EXCEL 2021                                                                    CHAPTER


















                    LEARNING OUTCOMES                                                                            95%


                    The student will be able to:
                       understand how to select a range of cells.
                       edit cell contents efficiently.
                       use Undo and Redo to manage changes.
                       delete cell contents, cells, rows or columns.
                       insert cells, rows or columns.
                       copy and move the data within or across worksheets.
                       use Autofill for quick data entry.
                       adjust column width and row height for better visibility.




                 In this chapter, we will learn the basics of Excel. We will explore how to select a range of
                 cells, edit cell contents, use undo and redo commands, and delete data. We will also learn
                 how to insert and delete cells, rows, or columns, copy and move data, use Autofill, and
                 adjust column width and row height.




                           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                   LEFT/RIGHT ARROW
                 use the arrow keys to move to change the active cell.

                 SELECTING A ROW








                         Click here to select an entire row




                                                                                               Editing in Excel 2021  7
   4   5   6   7   8   9   10   11   12   13   14