Microsoft KB Archive/24909

Excel: Quick Insertion of Rows or Columns on a Worksheet 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: Hold down the OPTION key. 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 KBSubcategory: 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.