Chapter 5. Controlling Rows, Columns, and Cells

Chapter 5. Controlling Rows, Columns , and Cells

In this chapter

• Widening columns and wrapping text in cells.

• Making rows taller or shorter.

• Locking columns and rows in place, to prevent them from scrolling off the screen.

• Inserting rows, columns, and cells.

• Removing rows, columns, and cells.

If you ever filled out a form at your doctor's office, you know that the blanks are never the right size for your entries. The Name blank is way too wide, the phone number blank is far too narrow, and if you live in a town with a long name , like Indianapolis, you can barely squeeze in the city name. Fortunately, the blanks (cells) that make up your worksheets are much more flexible. You can stretch the cells to make them wider or taller; squeeze them to make them short and skinny; force them to wrap long text entries; and even add rows, columns, and cells when you run out of blanks. This chapter teaches you the techniques you need to take control of the rows, columns, and cells that comprise your worksheet.