© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_4

4. Formatting and Aligning Data

David Slager

(1)Fort Wayne, Indiana, 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 certain entries (e.g., totals) and making the worksheet ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.