Microsoft Office Tutorials and References
In Depth Information
Putting the headers into your address book
You can save time by downloading my sample fi 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 fi 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!
Selecting cells
As ever, the boffi 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 fi rst cell and hold the mouse button down while you move
the mouse.
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 fi 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 fi 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 fi nd
easiest, but you can get by just using the fi 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.
Search JabSto ::

Custom Search