Microsoft Office Tutorials and References
In Depth Information
Entering your friends into your address book
There is another way you can see more of what’s in a cell, and that’s to wrap the text
in it. That means Excel will stretch the cell vertically and let the text run over
multiple lines within that cell, so that you can see everything. To switch that on, just
select a cell (or group of cells) and then click the Wrap Text button, shown in Figure
4.7. (You do exactly the same to turn it off again.) You can see an example in Figure
4.8, which is an extract from my address book where I’ve made the addresses wrap.
Because the rows have different onscreen heights it can make the spreadsheet look
untidy, so I prefer to adjust the column widths to show everything.
You can also select some cells (such as by clicking on a column heading),
click the Format button, and choose Autoﬁ t Column Width from the menu.
As I said earlier, it’s a good idea to break your content down into the smallest
useful chunks, but sometimes you might want to put a lot of text into a cell. You might
be cataloguing your music collection in Excel, for example, and want to include
detailed notes for each album, which can’t be divided up sensibly. If you’re
putting a lot of text into a cell, you can add a ‘soft return’ to move to a new line within
that cell by pressing Alt+Enter. (Don’t get it confused with the Shift+Enter you use
in Word to start a new line without starting a new paragraph.)
Editing information in cells
If you press the wrong key when you’re typing into a cell, you can press the
Backspace key straight away to change it. But the most devious mistakes are only
spotted later. If you press the cursor key to go back when you’re entering text into a