Excel shortcuts

The 5 Best Keyboard Shortcuts for Inserting Rows in Excel on a Mac

If you're a Mac user, you know that there are some things that just work better with a keyboard shortcut. And when it comes to inserting rows in Excel, there are definitely some keyboard shortcuts that can make your life a whole lot easier. Here are the 5 best keyboard shortcuts for inserting rows in Excel on a Mac:

  1. Command + Option + I - This shortcut will insert a new row above the row that you currently have selected.
  2. Command + Option + E - This shortcut will insert a new row below the row that you currently have selected.
  3. Command + Option + Shift + I - This shortcut will insert a new row above the row that you currently have selected, and will also shift the other rows down one.
  4. Command + Option + Shift + E - This shortcut will insert a new row below the row that you currently have selected, and will also shift the other rows down one.
  5. Command + Option + Shift + R - This shortcut will insert a new row above the row that you currently have selected, and will also shift the other rows up one.

As you can see, there are a few different keyboard shortcuts that you can use to insert rows in Excel on a Mac. And each one has its own specific purpose. So, depending on what you're trying to do, you can use the shortcut that best suits your needs.

Do you have a favorite keyboard shortcut for inserting rows in Excel on a Mac? If so, share it with us in the comments below!

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.