Microsoft KB Archive/24909

From BetaArchive Wiki

Excel: Quick Insertion of Rows or Columns on a Worksheet

Last reviewed: October 31, 1994
Article ID: Q24909


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.

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.