Book II

Worksheet Design

Check out the article “Selecting Cells with the Keyboard in Excel 2016” online at www.dummies.com/extras/excel2016aio.

Contents at a Glance

1. Chapter 1: Building Worksheets
   1. Designer Spreadsheets
   2. It Takes All Kinds (Of Cell Entries)
   3. Data Entry 101
   4. Saving the Data
   5. Document Recovery to the Rescue
2. Chapter 2: Formatting Worksheets
   1. Making Cell Selections
   2. Adjusting Columns and Rows
   3. Formatting Tables from the Ribbon
   4. Formatting Tables with the Quick Analysis Tool
   5. Formatting Cells from the Ribbon
   6. Formatting Cell Ranges with the Mini-Toolbar
   7. Using the Format Cells Dialog Box
   8. Hiring Out the Format Painter
   9. Using Cell Styles
   10. Conditional Formatting
3. Chapter 3: Editing and Proofing Worksheets
   1. Opening a Workbook
   2. Cell Editing 101
   3. A Spreadsheet with a View
   4. Copying and Moving Stuff Around
   5. Find and Replace This Disgrace!
   6. Spell Checking Heaven
   7. Looking Up and Translating Stuff
   8. Marking Invalid Data
   9. Eliminating Errors with Text to Speech
4. Chapter 4: Managing Worksheets
   1. Reorganizing the Worksheet
   2. Reorganizing the Workbook
   3. Working with Multiple Workbooks
   4. Consolidating Worksheets
5. Chapter 5: Printing Worksheets
   1. Printing from the Excel 2016 Backstage View
   2. Quick Printing the Worksheet
   3. Working with the Page Setup Options
   4. Headers and Footers
   5. Solving Page Break Problems
   6. Printing the Formulas in a Report