1. Computing

Entering Data in Microsoft Works Spreadsheets

By , About.com Guide

4 of 6

Widen Columns in Microsoft Works Spreadsheets
Microsoft Works Spreadsheets Tutorial

Microsoft Works Spreadsheets Tutorial

� Ted French

Widen Columns in Microsoft Works Spreadsheets

Sometimes data is too wide for the cell it is located in. When this happens, the data may or may not spill over into the cell beside it.

  • If a label is too long for a cell but there is nothing in the cell to the right of it the label simply spills over into the space to the right (see cell B2 in the image above).

  • If a label is too long for the cell but there is data in the cell to the right, the label is cut off. The rest of label is still present, there just isn�t room to display it (see cell B4 in the image above).

If a label is cut off, you can widen the column to display it. In Microsoft Works spreadsheets, you can't widen individual cells, you must widen the entire column.

Example - Widen Column B:

  • Place your mouse pointer on the line between Columns B and C in the column header.
  • When the pointer changes to a double headed arrow, click with the mouse button and drag to the right.

©2013 About.com. All rights reserved.