Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To Save a Workbook
You should organize
and store i les in folders
so that you easily can
i nd the i les later. For
example, if you are taking
an introductory computer
class called CIS 101, a good
practice would be to save
all Excel i les in an Excel
folder in a CIS 101 folder.
For a discussion of folders
and detailed examples
of creating folders, refer
to the Ofi ce 2010 and
Windows 7 chapter at the
beginning of this topic.
You have performed many tasks while creating this workbook and do not want to
risk losing work completed thus far. Accordingly, you should save the workbook.
The following steps assume you already have created folders for storing your
i les, for example, a CIS 101 folder (for your class) that contains an Excel folder (for
your assignments). Thus, these steps save the workbook in the Excel folder in the CIS
101 folder on a USB l ash drive using the i le name, Save Sable River Foundation. For
a detailed example of the procedure summarized below, refer to the Ofi ce 2010 and
Windows 7 chapter at the beginning of this topic.
With a USB l ash drive connected to one of the computer’s USB ports, click the Save button
on the Quick Access Toolbar to display the Save As dialog box.
Type Save Sable River Foundation in the File name text box to change the
i le name. Do not press the ENTER key after typing the i le name because you do not want
to close the dialog box at this time.
Navigate to the desired save location (in this case, the Excel folder in the CIS 101 folder
[or your class folder] on the USB l ash drive).
Click the Save button (Save As dialog box) to save the document in the selected folder on
the selected drive with the entered i le name.
If you wish to take a break, this is a good place to do so. You can quit Excel. To resume at a later time, start
Excel, open the i le called Save Sable River Foundation, and continue following the steps from this location forward.
Formatting the Worksheet
The text, numeric entries, and functions for the worksheet now are complete. The next
step is to format the worksheet. You format a worksheet to emphasize certain entries and
make the worksheet easier to read and understand.
Figure 1– 26a shows the worksheet before formatting. Figure 1– 26b shows the work-
sheet after formatting. As you can see from the two i gures, a worksheet that is formatted
not only is easier to read but also looks more professional.
Identify how to format various elements of the worksheet.
By formatting the contents of the worksheet, you can improve its overall appearance. When
formatting a worksheet, consider the following formatting suggestions:
Increase the font size of cells.
An increased font size gives more impact to the text in
a cell. In order to indicate their relative importance, worksheet titles should have the
largest font size, followed by worksheet subtitles, and then column and row headings.
Change the font color of cells.
Different cell colors help the reader of a worksheet
quickly differentiate between the sections of a worksheet. Worksheet titles and subtitles
easily should be identii able from column and row headings. The overuse of too many
colors, however, may be distracting to the reader of a worksheet.
Center the worksheet titles, subtitles, and column headings.
Centering text in worksheet
titles and subtitles over the portion of the worksheet that they represent helps the
reader of a worksheet quickly to identify the information that is of interest to them.