Rows or columns can be inserted easily by selecting the rows or columns currently occupying the place where the blank ones are needed. When Excel inserts the rows or columns, it shifts any selected rows down and moves selected columns to the right.
In our case today, we realized that we have left out some columns of data related to household income, participant comments, and possibly other data as well. We will insert new columns and enter the missing data.
Inserting and Deleting Columns
The number of columns that are inserted will depend on the number of columns that are selected. We will select three columns to insert three new columns. The blank columns will be inserted to the left of the selected columns by default.
Step1. To select Columns C, D, and E, in the column heading selection area, with the down-pointing arrow,
Press & Drag columns C, D, and E
Step2. To insert the new blank columns,
Right-Click the selection, Click Insert
NOTE for MacOS Users: To insert the new blank columns, press: Control key+Click the selection, Click Insert.
: To insert columns from the Ribbon, on the Home command tab, in the Cells group, Click Insert.
Step3. To begin to enter the missing heading,
Click cell C1
Step4. To enter our first missing heading, type:
Household Income Tab key
Step5. To enter our second missing heading, type:
Step6. To enter our missing data point, if necessary,
Click cell C2
Step7. To enter our first participant's income level, type:
Step8. To enter our second participant's income level, if necessary,
Click cell C3
Step9. To enter our second participant's income level, type:
45000 Tab key
Step10. To begin to enter a comment recorded by our second participant, if necessary,
Click cell D3
Step11. To enter the comment, type:
I would like more computer assistance Enter
Step12. To remove column E,
Right-Click column , Click Delete
NOTE for MacOS Users: To delete column E, press: Control key+Click the column E heading, Click Delete.
Step13. Deselect the cells.
Step14. Save the workbook.