If you want to insert blank rows in every other row, you may need to insert them one by one, but the Insert Blank Rows & Columnsof Kutools for Excel can solve this job in seconds. Select the entire row/column you want to delete, if you want to delete several rows/columns at once time, press Ctrl key to select them, then press Ctrl+ - keys delete.īatch insert blank rows or columns in a specific interval in Excel range Tip: If you want to add several rows/columns at once time, for example, insert five rows/columns, select entire five rows/columns by clicking Ctrl key first, then press Ctrl + + keys or Shift + Ctrl + + keys, then new blank five rows/columns are inserted. If your keyboard has no Keypad, you can press Shift + Ctrl + + keys to insert rows or columns. Select an entire row/column that you want to add a row/column above or left of it, and then press Ctrl + + keys, then a new blank row/column added above/left of your selected row/column. But actually, you can easily use shortcut keys to quickly insert or delete row/column/tab as you need in Excel. In daily Excel working, to insert or delete a row or a column or a sheet tab is usually used.

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

Microsoft excel shortcut keys 2007