After learning about “How to Fill Data Automatically in Excel Worksheet Cells”, now we will learn about how to insert columns, and rows in excel?. So let’s start…..
How to Insert Column?
To insert a single column in between the data, select the column and go to the “Home” tab,
under the “Cells” group click on the “Insert” option dropdown list will appear in that select “Insert Sheet Columns“. Like this:
Insert Column Via Shortcut Key
To insert a column via a shortcut key, press “CTRL + Spacebar” to select the column and hold the “CTRL” key and press the “+” key, let’s see
Insert Multiple Column
To insert columns via a shortcut key, press “CTRL + Spacebar” to select the column and hold the “CTRL” key and press the “+” key
For inserting multiple columns hold the “CTRL” key and press the “+” key number of times,
For e.g if you want to insert two-column press it 2 times for 3 column press it 3 times like this:
Delete Column
To delete a column in between the data, select the column and go to the “Home” tab,
under the “Cells” group click on the “Delete” option dropdown list will appear in that select “Delete Sheet Columns“. Like this:
Delete Column Via Shortcut Key
To insert a column via a shortcut key, press “CTRL + Spacebar” to select the column and hold the “CTRL” key and press the “-“ key, let’s see
How to Insert Row?
To insert row select the row and under “Home” tab in the “Cells” group click on the “Insert”
Select the option “Insert Sheet Rows” like this:
Insert Row Via Shortcut Key
To insert row via a shortcut key, press “SHIFT + Spacebar” to select the row and hold the “CTRL” key and press the “+” key
How to Delete Row?
If you are working in excel and in the between data you want to delete a row.
Select that row and go to “Home” tab under the “Cells” group select the option “Delete Sheet Rows”. Let’s see
Delete Row via Shortcut Key
To delete row via a shortcut key, press “SHIFT + Spacebar” to select the row and hold the “SHIFT” key and press the “-“ key, let’s see
For Latest Updates & Learning Join Our YouTube Channel: Join Now
