

Inserting rows and columns in Excel is quite straight forward:
Now your selected column will move right and you’ll get a new column. Please note the following comments:
There is a faster way of inserting rows and columns in Excel: Usuing keyboard shortcuts (please also refer to the complete list of keyboard shortcuts in Excel).
Inserting a column works almost the same way:
So, you have learnt 3 shortcuts altogether: Select a row/column with “Shift/Ctrl + Space” and add a row/column with “Ctrl + ‘+’ “. Isn’t it quite easy?
One more comment: Deleting a row or column works the similar way: Select a row or column and delete it by pressing “Ctrl + ‘-‘ “
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Test