Microsoft® Office 2007 On Demand

11. Designing a Worksheet with Excel

What You’ll Do

Format Numbers

Apply and Create Cell Styles

AutoFormat Text While You Type

Apply Conditional Formatting

Create and Manage Conditional Formatting

Control Text Flow

Format Tabs and Background

Add Borders to Cells

Set Up the Page

Adjust Page Margins

Add Headers and Footers

Insert Page Breaks

Customize Worksheet Printing

Set the Print Area

Introduction

Microsoft Office Excel offers several tools for making your worksheets look more attractive and professional. Without formatting, a worksheet can look like a sea of meaningless data. To highlight important information, you can change the appearance of selected numbers and text by adding dollar signs, commas, and other numerical formats. If you want ...