Microsoft Office Tutorials and References
In Depth Information
Using the Auto-fit Feature
Using the Auto-fit Feature
Let's try an auto-fit:
As with the Method 1, glide the mouse atop the right column boundary,
until you see the double-arrowed cursor.
Double-click the mouse. The column should be widened to reveal all of
the contents of the cell.
Got that? Again, it’s called auto-fit, and we see that double-clicking any column’s right
boundary resizes the column until all the data in that column is revealed. And that also
means that if you’ve entered data into many cells in the B column and many of them
exhibit obscured text, a double-click will widen the column to reveal them all. In other
words, the auto-fit resizes the column to the width of the widest data entry in the
You can execute an auto-fit on several columns at the same time. That means that if several
columns suffer from the obscured-text-syndrome at the same time, you can widen them all
in one shot. Here’s how: Let’s say that columns A through D all have data in some of their
cells which are hidden by data in the adjoining columns, something like this:
Figure 2–14. But the words get in the way…four columns’ worth of obscured text.
Click atop the first column heading you want to auto-fit (in this case, A)—
and not its boundary, this time—keep the left button down, and drag
across the headings of the adjoining columns you want to auto-fit:
Search JabSto ::

Custom Search