Office 2013 On Demand

11. Designing a Worksheet with Excel

What You’ll Do

Format Numbers

Apply and Create Cell Styles

Apply Conditional Formatting

Create and Manage Conditional Formatting

Create Sparkline Formatting

Control Text Flow

Format Tabs and Background

Add Borders to Cells

Set Up the Page

Insert Page Breaks

Adjust Page Margins

Add Headers and Footers

Customize Worksheet Printing

Set the Print Area

Introduction

Microsoft 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 to format ...