Page 29 - TP_Prime_v2.2_Class_6
P. 29
03
MORE ON EXCEL
Learning Objectives
• Selecting Cells in a Worksheet MORE ON EXCEL
• Copying/Moving Data
• Column Width and Row Height
• Inserting Rows/Columns
• Merging Cells
• Splitting Cells
• Formatting Spreadsheets
Yesterday my teacher gave me a data • Customising Worksheet Tab
• Using Formulas to Perform Calculation
to enter into an Excel worksheet. • Auto Fill 27
When I started entering data, I saw • Order of Operation
that some cells contain similar data.
Can I copy the data in a cell into another cell?
Yes, we can copy the data in a cell into another cell. Let's learn about how to
copy the content of a cell.
In the previous class, you learnt the basics of Excel such as creating a workbook, entering
data and saving workbook. In this chapter, you are going to learn more about Excel.
Selecting Cells in a Worksheet
Apart from entering data into a worksheet, Excel, 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 allows us to select a single cell or a group of cells. To select cells in Excel, follow
these steps:
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.
We 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 we want to make a selection.

