Objective 3. Use AutoFormat

When you format data in a worksheet, choose a combination of formatsfonts, font sizes, font colors, emphasis, text alignment, and so onthat looks attractive together. Doing so will assist the reader in distinguishing the titles, data, and totals in the worksheet.

Excel has a set of predefined formats that already have attractive formatting in placethe AutoFormat feature. It is usually faster to apply an AutoFormat, and then customize it, if necessary, rather than applying single formats one by one.

Activity 2.4. Formatting a Range of Cells Using AutoFormat

Because this worksheet will be posted on the staff bulletin board where the concession stand employees can see the schedule assignments, in this activity, you will apply an AutoFormat to make the worksheet easier to read. Applying distinctive formats visually identifies important ranges within a worksheet.


Click in the Name Box, type a1:p9 and then press . Alternatively, select the range by dragging with your mouse.

When working with a worksheet that extends beyond the visible window, it is usually faster to type the range in the Name Box rather than to select the range by draggingespecially if the window scrolls too fast to control it easily.


From the Format menu, click AutoFormat. In the AutoFormat dialog box, scroll down and click the List 3 format. Compare your screen with Figure 2.10.

Figure 2.10.

It is easier for a reader's eyes to follow down a column of information than it is to follow across a row of information. Thus, applying a format that differentiates the rows visually is useful. If you are using a black and white printer, select an AutoFormat with a minimal amount of color or shadingit will be easier to read.


In the AutoFormat dialog box, click the Options button. Under Formats to apply, clear the Alignment check box, which will remove the centering format from the column titles.



With all of the options except Alignment selected, in the AutoFormat dialog box, click OK, and then click in any empty cell to cancel the selection. Compare your screen with Figure 2.11.

Figure 2.11.



In the Name Box, type c4:p9 and then press . Center the selected names, and then click any empty cell to cancel the selection.


In the row heading area, drag the lower edge of row 1 downward to increase the row height to 45 pixels. Select rows 2:9 and increase the row height to 40 pixels. Click cell A1 and change the Font Size to 26. In the Name Box, type a2:p2 press , and then change the Font Size to 18.



Select the range I3:I9, and then click the Borders button arrow . From the displayed menu, in the first row, click the fourth borderRight Border. Click any cell to cancel the selection, and then compare your screen with Figure 2.12.


Figure 2.12.



Save your changes.

More Knowledge: Using Gridlines

When you use large worksheets, horizontal lines between rows make it easier for the reader to follow rows across and vertical lines make it easier to follow columns downward. An alternative to formatting a large range of cells with one of the AutoFormat options is to select the Gridlines option that provides a grid of horizontal and vertical lines. The Gridlines option is on the Sheet tab of the Page Setup dialog box.

[Page 707 (continued)]

Objective 4 View, Scroll, and Print Large Worksheets

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net