• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3: Formatting and Editing Worksheets > Worksheet Formatting Techniques

Chapter 8. Worksheet Formatting Techniques

Formatting Fundamentals 195

Formatting in Cells 200

Creating Custom Formats 211

Aligning Data in Cells 219

Aligning Text Vertically 222

Using Fonts 226

Customizing Borders 228

Applying Colors and Patterns 231

Controlling the Size of Cells 234

When creating a worksheet in Microsoft Excel, you probably don't ask yourself the question: Why use formats? But we'll answer it anyway. Compare Figure 8-1 to Figure 8-2 and we need say no more. Although the data is the same in both worksheets, the worksheet in Figure 8-2 takes advantage of the formatting features available in Excel and is therefore much easier to read and interpret. Proper use of formatting helps transform data into information; this chapter shows you how to do just that.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint