Page 92 - Excel 2013 All-in-One For Dummies

Contents at a Glance
Chapter 1: Building Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .75
Designer Spreadsheets ................................................................................. 75 It Takes All Kinds (Of Cell Entries)..............................................................85 Data Entry 101................................................................................................92 Saving the Data ............................................................................................ 116 Document Recovery to the Rescue ........................................................... 122
Chapter 2: Formatting Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . .125
Making Cell Selections ................................................................................ 126 Adjusting Columns and Rows .................................................................... 134 Formatting Tables from the Ribbon..........................................................139 Formatting Tables with the Quick Analysis Tool .................................... 143 Formatting Cells from the Ribbon ............................................................. 144 Formatting Cell Ranges with the Mini-Toolbar ........................................ 148 Using the Format Cells Dialog Box ............................................................ 149 Hiring Out the Format Painter ................................................................... 168 Using Cell Styles........................................................................................... 169 Conditional Formatting...............................................................................174
Chapter 3: Editing and Proofing Worksheets . . . . . . . . . . . . . . . . . . . .183
Opening a Workbook................................................................................... 184 Cell Editing 101 ............................................................................................ 190 A Spreadsheet with a View.........................................................................198 Copying and Moving Stuff Around ............................................................ 206 Find and Replace This Disgrace!................................................................ 216 Spell Checking Heaven................................................................................222 Looking Up and Translating Stuff .............................................................. 225 Marking Invalid Data ................................................................................... 226 Eliminating Errors with Text to Speech....................................................228
Chapter 4: Managing Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .231
Reorganizing the Worksheet ...................................................................... 231 Reorganizing the Workbook.......................................................................247 Working with Multiple Workbooks............................................................ 258 Consolidating Worksheets ......................................................................... 262
Chapter 5: Printing Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .269
Printing from the Excel 2013 Backstage View..........................................270 Quick Printing the Worksheet.................................................................... 276 Working with the Page Setup Options ...................................................... 277 Headers and Footers ................................................................................... 285 Solving Page Break Problems..................................................................... 292 Printing the Formulas in a Report ............................................................. 294