Microsoft Office Tutorials and References
In Depth Information
Entering your friends into your address book
If you ﬁ nd it hard to see what you’re doing, you can magnify the screen using
the slider in the bottom right (shown in Figure 4.1), the same way as in Word.
Changing the width of a column
When you start Excel, all the cells are the same size, and they’re fairly narrow.
Some of your columns, such as the street column, need much more space than
others, such as the postcode. Excel gives you control over how wide the columns
are on screen, so you can have a wide column for the street and a narrow one for
the postcode, for example.
Changing the width of a column doesn’t affect what’s stored in a cell; it just
affects how much of it you can see at once on screen.
Let’s start by changing the width of the address column. Between the column
headings there are thin lines, which are the column dividers. You can move these
around to change the size of the columns. Click the line between the headings for
columns C and D, and hold down the mouse button. Your mouse pointer will turn
into a vertical line with two horizontal arrows on it, shown in Figure 4.7. If you
move the mouse to the right, the column divider will move with it as a dotted line.
When you release the mouse button, the column divider stays where you left it.
The column to its left (column C in this example) stretches or shrinks to meet the
column divider. The next column along (D, in our case) stays the same size but is
moved left or right so that it stays snug against where column C ends.
As you can probably tell, I’ve made up a lot of ﬁ ctional people for my address
book, rather than publishing my real one in this topic. Any similarity in the
screenshots to characters living or dead is purely coincidental!
You can change the size of rows, too, by changing the row dividers. You’ll
need to do that much less often, though.