Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Working with Rows and Columns

Working with rows and columns is very much like working with cells on a larger scale. When you insert a row, the new row spans all the columns in the worksheets. New columns and rows don't contain data and are unformatted. (You'll learn about adding formatting later in Part II: “Dress Up Your Work.”)

Insert a new row or column by clicking the spot where you want the new row or column to appear. If you want to insert more than one row or column, select the number of rows and columns you want. (For example, select three rows if you want to insert three new ones.) Click the Insert menu, as shown in Figure 2.11, and choose either Rows or Columns. Excel inserts new rows above the current row and inserts new columns to ...