Chapter 4. Formatting Your Worksheets

by Sherry Kinpoth

• Basic worksheet formatting

  Learn how to use basic formatting commands; change fonts and sizes, style (bold, italics, and underline), and alignment.

• Formatting tips and tricks

  Speed up your formatting tasks using Excel's special formatting tools, such as AutoFormat and the Format Painter.

• Mastering number formats

  Learn to add formatting, such as currency or comma styles, to your numbers to define their meaning. Also, find out how to create custom number formats and use Excel's preset number styles.

• Changing cell appearance

  Add borders, patterns, color, and shading to your worksheet cells to give your data a polished, professional look.

• Changing rows and columns

  Tips and tricks for altering the size of rows and columns, hiding confidential data, and merging cells.