Office 2010 Made Simple

Working with Rows and Columns

To arrange the data in your worksheets, you can insert and delete rows, columns, and cells. To make the data visible and easy to read, you can change the width of columns and the height of rows. And when you don't need to see particular rows or columns, you can hide them.

Inserting and Deleting Columns, Rows, and Cells

You can quickly insert columns or rows in a worksheet to give yourself more space to work in.

TIP: To tell Excel how many columns or rows you want to insert, select the same number of existing columns or rows.

Inserting Columns and Rows

Figure 12–1 shows you the quickest and easiest way to insert columns in a worksheet: select the column or columns before which you want to insert the new columns, ...