Skip to main content

Excel Tips: Insert > Rows and Columns

Insert Rows

How to add subtotals and total row in a table in Excel?

How to auto insert row based on cell value in Excel?

How to automatically insert rows in Excel?

How to copy and insert row multiple times or duplicate the row x times in Excel?

How to insert a blank new row automatically by Command Button in Excel?

How to insert blank row above specific text in Excel?

How to insert blank row based on above cell value in Excel?

How to insert blank rows when value changes in Excel?

How to insert multiple rows or columns quickly in Google sheets?

How to insert numbers or rows for missing sequential numbers in Excel?

How to insert or delete partial row in Excel?

How to insert or delete rows in protected sheet?

How to insert specific number of rows at fixed intervals in Excel?

How to quickly insert blank /empty rows in Excel?

How to quickly insert multiple blank rows or columns in Excel at once?

How to quickly insert space between each row in Excel?

How to repeat heading row every nth row in Excel?

How to repeat rows a specified number of times based on another column in Excel?

How to use macro to insert row below table in Excel?

Insert Columns

How to insert columns left to a table in Excel?

How to quickly insert blank column between every other column in Excel?

How to insert multiple rows or columns quickly in Google sheets?

How to quickly insert multiple blank rows or columns in Excel at once?

Others

How to disable ability to insert row and column in Excel?

How to use shortcut keys to insert or delete row/column/tab in Excel?