Question

how will you insert blank cell ,blank column and blank row in spread sheet?​

Answer 1

Explanation:

To insert new blank Cells in Excel worksheet, follow these steps.

Step 1 - Select the location and number of Cells you want to insert in Excel worksheet. You can insert a single Cell or Range of Cells in Excel worksheet, either in rectangle or square shape. In this example, I want to insert six Cells at Range address B4:C6, as shown below.

Select location and number of Cells in Excel worksheet

Step 2 - After selecting the location and number of Cells, right-click on any of the selected Cell and select "Insert" from context menu as shown in below image.

Right-click to insert new Cells in Excel worksheet

Another way to achieve the same result is by running "Insert Cells" command from Excel Ribbon > "Cells" Group > "Insert" menu button as shown below.