Page 231 - IT_Play_V1.0 Class9
P. 231
Cutting/Copying the Contents
The contents of a cell or a range of cells can be cut or copied from one place to another. Following are the
steps to do so:
Step 1: Select the cell or range of cells that is to be cut or copied.
Step 2: Click on the Edit menu from Menu bar.
Step 3. Select the Cut or Copy option from the drop-down menu. OR Click on the Cut or Copy icon from
the Standard toolbar.
To paste the contents at another position:
Step 1: Click on the cell where it has to be pasted.
Step 2: Click on the Edit menu from Menu bar.
Step 3. Select the Paste option from the drop-down menu. OR Click on the Paste icon from the Standard
toolbar.
The selected content gets pasted at the new location.
Inserting Rows and Columns
To insert a new row in a sheet, follow the given steps:
Step 1: Select the row where you want to insert a new row above or below.
Step 2: Click on Sheet menu from Menu bar.
Step 3: Select Insert Rows option from the drop-down menu. Select the desired option from the sub-menu.
Step 4: Select Rows Above to add rows above the selected row.
The new row will appear on the screen.
2
3 4
1
To insert a new column in a sheet, follow the given steps:
Step 1: Select the column where you want to insert a new column before or after.
Step 2: Click on Sheet menu from Menu bar.
Step 3: Select Insert Columns option from the drop-down menu. Select the desired option from the
sub menu.
Step 4: Select Columns Before to add columns to the left of the selected column.
The new column will appear on the screen.
Applying Formula and Functions in Spreadsheet 229

