Excel shortcuts

15 Excel Shortcuts for Adding Rows and Columns

If you're an Excel power user, you know that adding rows and columns is a common task. And while you can always use the mouse to click and drag to insert rows and columns, there are a few keyboard shortcuts that can save you time.

Here are 15 shortcuts for adding rows and columns in Excel:

  1. Ctrl+Shift++ (plus sign): Inserts a new row above the row where your cursor is currently located
  2. Ctrl+Shift+- (minus sign): Inserts a new column to the left of the column where your cursor is currently located
  3. Ctrl++ (plus sign): Inserts a new row below the row where your cursor is currently located
  4. Ctrl+- (minus sign): Inserts a new column to the right of the column where your cursor is currently located
  5. Alt+H, O, I: Inserts a new row above the row where your cursor is currently located
  6. Alt+H, O, U: Inserts a new column to the left of the column where your cursor is currently located
  7. Alt+H, O, L: Inserts a new row below the row where your cursor is currently located
  8. Alt+H, O, R: Inserts a new column to the right of the column where your cursor is currently located
  9. Alt+H, I: Inserts a new row above the row where your cursor is currently located
  10. Alt+O, U: Inserts a new column to the left of the column where your cursor is currently located
  11. Alt+O, L: Inserts a new row below the row where your cursor is currently located
  12. Alt+O, R: Inserts a new column to the right of the column where your cursor is currently located
  13. Shift+Spacebar: Selects the entire row where your cursor is currently located
  14. Ctrl+Spacebar: Selects the entire column where your cursor is currently located
  15. Ctrl+Shift+Spacebar: Selects the entire worksheet
  16. Ctrl+Home: Moves the cursor to the upper-left corner of the worksheet
  17. Ctrl+End: Moves the cursor to the bottom-right corner of the worksheet

Do you have a favorite shortcut for adding rows and columns in Excel? Share it with us in the comments!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.