Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Tap or click the Save button on the Quick Access Toolbar, which depending on settings,
will display either the Save As gallery in the Backstage view or the Save As dialog box.
To save on a hard disk or other storage media on your computer, proceed to Step 2a.
To save on SkyDrive, proceed to Step 2b.
2a If your screen opens the Backstage view and you want to save on storage media on
your computer, tap or click Computer in the left pane, if necessary, to display options
in the right pane related to saving on your computer. If your screen already displays
the Save As dialog box, proceed to Step 3.
2b If your screen opens the Backstage view and you want to save on SkyDrive, tap or click
SkyDrive in the left pane to display SkyDrive saving options or a Sign In button. If your
screen displays a Sign In button, tap or click it and then sign in to SkyDrive.
Tap or click the Browse button in the right pane to display the Save As dialog box
associated with the selected save location (i.e., Computer or SkyDrive).
Type Bob Gleamin Budget in the File name box to change the le name.
Do not press the ENTER key after typing the 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 your computer or SkyDrive).
Tap or click the Save button (Save As dialog box) to save the workbook in the selected
folder on the selected save location with the entered le name.
Break Point: If you wish to take a break, this is a good place to do so. You can exit Excel. To resume at a later time,
run Excel, open the le called Bob Gleamin Budget, 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– 29a shows the worksheet before formatting. Figure 1– 29b shows the
worksheet after formatting. As you can see from the two gures, a worksheet that is
formatted not only is easier to read but also looks more professional.
The key to formatting a worksheet is to consider the ways you can enhance the worksheet so that it appears professional. When
formatting a worksheet, what steps should you consider?
• Identify how to format various elements of the worksheet.
• Increase the font size of cells.
• Change the font color of cells.
• Center the worksheet titles, subtitles, and column headings.
• Modify column widths to best t text in cells.
• Change the font style of cells.
To change the unformatted worksheet in Figure 1– 29a so that it appears like the
formatted worksheet in Figure 1– 29b, the following tasks must be completed:
1. Change the font, change the font style to bold, increase the font size, and change
the font color of the worksheet titles in cells A1 and A2.
2. Center the worksheet titles in cells A1 and A2 across columns A through N.