. Point to Highlight Cells Rules , and then select Greater Than . 2. In the Greater Than dialog box, under Format cells that are Greater Than, enter $500 . 3. In the with cell select Custom Format. 4. In the Format Cells dialog box, on the Font tab, in the Font style box, select Bold Italic , and then click the Color arrow. Select Orange, Accent 5, Darker 50% .
Step 13 and 19: To Add a Header and a Footer 1. Make A1 the active cell. 2. Click Page Layout on the status bar. If necessary, use the Zoom Slider to adjust zoom to 100%. 3. Click Add header in the top margin of Page Layout view. The Design tab for Header & Footer Tools will appear on the ribbon. 4. Click the center section of the header, type Open Daily from 10 AM to 8 PM . 5. In the Navigation group, click Go to Footer . 6. Click the left section of the footer and add the file name code.
Step 16: To Rotate Text 1. Select cell range A4:D4 . 2. Click Home on the status bar. 3. In the Alignment group, click Orientation. 4. Select Angle Counterclockwise .
Step 18: To Change the Page Width 1. Click Page Layout on the status bar. 2. In the Scale to Fit group, click the arrow for Width. 3. Select 1 page .
You've reached the end of your free preview.
Want to read all 13 pages?
- Fall '10