Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 9 - 2615_KEC
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 |