Sometimes, when working with Excel we will need to insert multiple rows or columns within a worksheet. There are no obvious shortcuts for achieving this. Here are a set of key combinations that can be used to speed up multiple insertions of rows or columns.
- To insert a row, press Alt + i , and then “r” key.
- To insert a column, press ALT + i, and then “c” key.
- To repeat the last action, press F4 key. Keep pressing F4 key until the desired number of rows or columns are inserted.
