Quickly insert rows and columns into an Excel sheet

Use this easy-to-remember keyboard shortcut to insert rows and columns into your Excel sheets.

Inserting new rows and columns is an easy task. Simply select a row or column and choose Row or Column, respectively, from the Insert menu. Excel will insert a new row above the selected row and a new column to the left of the selected column.

Like most Excel tasks, you don't need your mouse at all. If you prefer, you can get the same results from the keyboard. Simply select a row or column and press [Ctrl]+[Shift]+=. You can delete a row or column just as quickly by pressing [Ctrl]+-. If you change your mind and want to delete a new row or column immediately after inserting it, just press [Ctrl]+Z.

About Susan Harkins

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox