More Formatting and Layout: Fresh Take

  • Create and apply conditional formatting
  • Change page layout with margins and orientation

Conditional formatting allows us to change the format of a cell based on the data within it.

Conditional Formatting


You can view the transcript for “Use conditional formatting” here (opens in new window).

Using print preview allows you to see where the page margins cut into the data. This is especially helpful if you end up needing to print your worksheet.

Margins and Page Layout

You can view the transcript for “Microsoft Excel – Setting Margins and Print Alignment” here (opens in new window).