Microsoft Office Tutorials and References
In Depth Information
Putting the headers into your address book
You can save time by downloading my sample ﬁ le and deleting the data in it.
Formatting your headers
It’s a good idea to make your column titles stand out from your information. On
the Home ribbon, the Font section should look familiar. It’s made up of controls
you’ve already seen in Word projects, including controls to change the font and
size, and to change the text style to bold or italic.
To make your ﬁ rst header bold, for example, put the cursor on that cell and then
click the Bold icon on the ribbon. To make all seven headers bold is going to take
14 mouse clicks, then, and if you want to colour them too, that’s going to be 21
clicks. That obviously won’t do! There’s got to be a quicker way!
As ever, the bofﬁ ns at Microsoft have made it easy for you. You just need to select
all the cells at once, and you can then format them in one go.
There are a few different ways to select a range of cells:
• Click on the ﬁ rst cell and hold the mouse button down while you move
• Click the grey row or column heading to select an entire row or column (see
Figure 4.4). You could click the 1 to select the whole row in this case. You can
also hold down the mouse button and move over multiple column or row
headings to select multiple columns or rows.
• Put the cursor on the ﬁ rst cell. Hold down the Shift key and use the cursor
keys to stretch the cursor to cover the range you want.
• Put the cursor on the ﬁ rst cell. Hold down the Shift key and click the last cell,
and Excel will select the range that joins them.
It’s worth trying these different methods of selecting cells to see which you ﬁ nd
easiest, but you can get by just using the ﬁ rst two. Your range of cells can all be in one row
or column, or it can be in a box shape that covers more than one row or column.