© David Slager and Annette Slager 2020
D. Slager, A. SlagerEssential Excel 2019https://doi.org/10.1007/978-1-4842-6209-2_4

4. Formatting and Aligning Data

David Slager1  and Annette Slager1
(1)
Fort Wayne, IN, USA
 

You’ll now learn how to refine the way your worksheets look on screen and in print. Excel provides many great options to establish a style for worksheets and the workbook as a whole that is distinctive and consistent.

After reading and working through this chapter, you should be able to
  • Format data and cell backgrounds

  • Create cell borders

  • Check which formats have been applied to the current cell

  • Align data

  • Copy the formatting from one cell to other cells

  • Format numeric data

  • Use Context Toolbars menus

Reasons for formatting data include emphasizing ...

Get Essential Excel 2019: A Step-By-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.