Page 52 - TP-Play_V-2.0_Book-5
P. 52
EDITING IN EXCEL 2016
06
Your Aim
to learn about:
Selecting Cells in a Worksheet Copying/Moving Data
Using Undo and Redo Features Column Width and Row Height
Inserting Rows/Columns Merging Cells
Autofill Customize Worksheet Tab
In the previous chapter, we have learned about different components of Excel 2016
window such as cell, row, column, formula bar, workbook and worksheet. We have
also learnt the process of creating a workbook, entering data into a worksheet and
saving a workbook. In this chapter, we will learn more about Excel 2016.
SELECTING CELLS IN A WORKSHEET
Apart from entering data into a worksheet, Excel 2016 also provides the facility to
perform various other operations with data such as modifying, inserting, moving/
copying and deleting. To perform all these operations, we first need to select the cell
that contains data. Excel 2016 allows us to select a single cell or a group of cells.
Single Cell: Click on the cell to select it.
Group of Cells or Range: Click on the first cell from where you want to start
the selection and drag the mouse diagonally up to the cell to which you want to
make selection. You can also select a range of cells by using the Shift key. Click
on the first cell and then press and hold the Shift key down, and click on the last
cell up to which you want to make selection.
Entire Row/Column: Click on the row heading to select the entire row or click
on the column heading to select the entire column.
Entire Worksheet: Click on the Select All button located below the Name box
to select the entire worksheet. Shortcut key to select the entire worksheet is
Ctrl + A.
52 Play (Ver. 2.0)-V

