This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Use the Border tab to apply single inside borders and single left, right and bottom borders (same color as the tab). Apply single side borders to rows 1:2 to complete the design. 7. Copy and paste cells A1:D4 on the Oregon sheet to the same range on the Nevada sheet. Click the Paste Options button and choose Keep Source Column Widths . Paste with the same options to the Washington sheet. 8. Copy cells B5:D11 from the Oregon sheet to the Nevada sheet. From the Paste Options, choose Formatting Only . Paste with the same options to the Washington sheet. 9. Change the fill and border colors on the Nevada sheet to match its tab color. Add a footer. Do the same for the Washington sheet. 10. Add a header to the Oregon sheet. Prepare and submit your work. 11.Save and close the workbook....
View Full Document
- Fall '11