Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide

Insert a Row p. 53

• The Rows command under the Insert menu inserts as many rows as you have selected above the selected row(s). So if you select three rows and use this command, it will insert three rows above the first selected row.

• If you select a column by clicking on its column heading, you can use the Columns command on the Insert menu to insert a column to the left of it.

• Excel automatically rewrites formulas as necessary when you insert a row or column.