Microsoft KB Archive/24909

{| = Excel: Quick Insertion of Rows or Columns on a Worksheet =
 * width="100%"|

Last reviewed: October 31, 1994

Article ID: Q24909

SUMMARY
To quickly insert rows or columns in a worksheet or macro sheet, hold down the OPTION key while selecting a number of rows or columns with the cursor.

For example, to insert 5 blank rows between rows 1 and 2:


 * 1) Hold down the OPTION key.
 * 2) Select rows 2 through 6 with the cursor.

When you use the OPTION+click shortcut to select whole rows or columns, the Insert dialog box does not appear.
 * }