Excel: Quick Insertion of Rows or Columns on a WorksheetLast reviewed: October 31, 1994 |
SUMMARYTo 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:
When you use the OPTION+click shortcut to select whole rows or columns, the Insert dialog box does not appear. |
KBCategory: kbother Last reviewed: October 31, 1994 |