Microsoft Office Tutorials and References
In Depth Information
5. Formatting a Worksheet
5. Formatting a Worksheet
What You’ll Do
Format Numbers and Text
AutoFormat Text While You Type
Apply Conditional Formatting
Create and Manage Conditional Formatting
Create Sparkline Formatting
Change Data Alignment
Control Text Flow
Change Data Color
Add Color and Patterns to Cells
Add Custom Colors
Add Borders to Cells
Format Tabs and Background
Copy Cell Formats
Understand, Apply, and Create Themes
Choose Theme Colors, Fonts, and Effects
Create, Apply, and Modify a Cell Style
Find and Replace Cell Formatting
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, or by applying attrib-
utes, such as boldface, italics, and underline.
Once you’ve set up your worksheet, additional changes are available to customize your
worksheet’s look. You can change the default font and font size, or maybe you’d like to
adjust the alignment of data in cells. In addition to column, row, or font changes, you can
add colors to cells or fonts, and include patterns to cells. You can also add borders around
Search JabSto ::




Custom Search