Microsoft Office Tutorials and References
In Depth Information
Printing your address book
To preview your printed page, in Ofﬁ ce 2010, you click the File tab and then click
Print. You can also access all the above options from here. In Ofﬁ ce 2007, click
the Ofﬁ ce button, ﬁ nd the Print part of the menu and then click Print Preview.
Tricks to help your address book print on one page
As you play with the print options, you’ll see dotted lines appear on your
spreadsheet to show you where the printed page ends. If you’re struggling to ﬁ t
everything onto one page widthways, there are two things you can try.
Firstly, you can try narrowing the columns. Don’t forget that double clicking on
the column dividers will snap the columns to the minimum necessary. You could
narrow them even further and use Word Wrap to make sure you can still see
You can also hide speciﬁ c rows or columns. If you only wanted to have the names
and phone numbers printed, for example, you would:
1. Select the Street, City, Postcode and Country columns by clicking the Street
heading, holding down the mouse button and moving the mouse right to
select the other columns.
2. Click the Home tab on the ribbon.
3. Click Format in the Cells part of the ribbon (see Figure 4.15).
4. Click Hide & Unhide on the menu that opens (see Figure 4.15).
5. Click Hide Columns.
As if by magic, the columns disappear. As with ﬁ ltering, nothing has been deleted –
it’s just hidden from view. This can be really confusing when you come back to the
spreadsheet later and ﬁ nd great chunks have vanished, so I recommend you
unhide columns when you’ve ﬁ nished. You can tell when a column is hidden
because its letter will be missing in the headings. You can see this in Figure 4.16,
where the column headings run A, B, G, H, which indicates that columns C, D, E,
and F are hidden from view.