INSERTING / DELETING CELLS, ROWS AND COLUMNS

As we already know that an Excel worksheet is always in grid format, i.e. in tabular format, still it allows you to do insertion and deletion of cell, rows and columns as and when required.

Inserting Cell

For inserting one or more cells in your worksheet, do the following steps:

Step 1 Select as many number of cells as you want to insert in your worksheet.

Step 2 Locate the Cells group under the Home tab.

Step 3 Click on the down-facing arrow below the Insert button.

Step 4 From the list that appears, select Insert Cells.

Step 5 From the Insert dialog box that appears, select the desired option.

Step 6 Click OK button.

Inserting Row/Column

Before inserting a row/column in a worksheet, you need to select that row/column which you want to insert the new row/column above or left.

For inserting one or more rows/columns in your worksheet, do the following steps:

Step 1 Select as many numbers of rows/columns as you want to insert in your worksheet.

Step 2 Locate the Cells group under the Home tab.

Step 3 Click on the down-facing arrow below the Insert button.

Step 4 From the list that appears, select Insert sheet rows/columns.

Deleting Cell

For deleting one or more worksheet, do the following steps

Step 1 Select as many number of cells as you want to delete from your worksheet.

Step 2 Locate the Cells group under the Home tab.

Step 3 Click on the down-facing arrow below the Delete button.

Step 4 From the list that appears, select Delete Cells.

Step 5 From the Delete dialog box that appears, select the desired option.

Step 6 Click OK button.

Deleting Rows/Columns

For deleting one or more rows/columns in your worksheet, do the following steps:

Step 1 Select as many numbers of rows/columns as you want to delete from your worksheet.

Step 2 Locate the Cells group under the Home tab.

Step 3 Click on the down-facing arrow below the Delete button.

Step 4 From the list that appears, select Delete Sheet Rows/Columns.

Changing Cell Height and Width

On a worksheet, you can specify a column width ranging from 0 to 255. This value represents the number of characters. The default column width is 8.43 characters. You can specify a row height from 0 to 409. This value represents the height measurement in points and the default row height is 15 points.

To Set a Column to a Specific Width

Steps to set a specific column width are as follows:

Step 1 Select the column or columns that you want to change. 

Step 2 On the Home tab, in the Cells group, click Format.

Step 3 Under Cell Size, click Column Width.

Step 4 In the Column Width Field, type the value that you want.

Tip To quickly set the width of a single column, right-click the selected column, click Column Width and then type the value that you want.

To Set a Row to a Specific Height

Steps to set a specific row height are as follows:

Step 1 Select the row or rows that you want to change.

Step 2 On the Home tab, in the Cells group, click Format.

Step 3 Under Cell size, click Row Height.

Step 4 In the Row Height box, type the value that you want.

Function and Charts

In MS-Excel, for doing various calculations in the cells of worksheet, formulas are used and to display the data in graphical form charts are used.

Using Formulas

Formulas are equations that perform calculations on values in your worksheet. It is an order of values, names, cell references, functions and operators in a cell that together give a new values. A formula always begins with = (equal) sign. e.g. if user wants to display the Sum of A5, B5, C5 and D5 in cell E5, user have to enter a formula ‘ = A5 + B5 + C5 + D5’ in a cell E5.

Leave a comment

Your email address will not be published. Required fields are marked *