Spreadsheets

Unit 2: Creating More Effective Spreadsheets

Lesson 5: Managing Worksheets and Workbooks


How do you change the width of a column (and the height of a row)?

There are three ways to change the width of a column and height of a row. The avi movie below demonstrates each method. The text following the avi movie discusses each explicitly.

Changing column width and row height

Note that you can't change the height or width of an individual cell. That is, you must always change all of the cells in the row or column. Why? Spreadsheets are organized around rows and columns. If you could change the height or width of an individual cell, there would be total chaos. Just imagine what a word processing document would look like if you split the document down the center and moved one half down one line.

Related concepts

When you are changing the size of a column that contains a number you may notice the number change to ####'s. When numbers are too wide to fit in the available display area they change to ####'s. If you want to learn more about this feature, see the related concept.

Previous Next


Copyright 1997 by the Curators of the University of Missouri