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

viii Excel 2013 All-in-One For Dummies
Cell Editing 101 ............................................................................................ 190 Undo and Redo................................................................................... 192 Get that out of here!........................................................................... 194 Can I just squeeze this in here?........................................................ 196
A Spreadsheet with a View.........................................................................198 “Zoom, zoom, zoom” ......................................................................... 199 Freezing window panes.....................................................................201 Saving custom views ......................................................................... 204
Copying and Moving Stuff Around ............................................................ 206 Doing it with drag-and-drop ............................................................. 206 Carried away with cut-and-paste ..................................................... 208
Find and Replace This Disgrace!................................................................ 216 Finding stuff........................................................................................216 Finding and replacing stuff ............................................................... 219
Spell Checking Heaven................................................................................222 Changing the spelling options.......................................................... 223 Adding words to the custom dictionary.........................................224
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 Inserting and deleting columns and rows....................................... 232 Eradicating columns and rows......................................................... 233 Adding new columns and rows........................................................233 Splitting the worksheet into panes..................................................234 Outlining worksheets ........................................................................ 237
Reorganizing the Workbook.......................................................................247 Renaming sheets................................................................................248 Designer sheets..................................................................................249 Adding and deleting sheets .............................................................. 251 Changing the sheets .......................................................................... 252 Group editing...................................................................................... 253 “Now you see them; now you don’t” ............................................... 254 Opening windows on different sheets............................................. 254
Working with Multiple Workbooks............................................................ 258 Comparing windows on different workbooks ................................ 258 Transferring data between open windows.....................................258 Transferring sheets from one workbook to another.....................259 Saving a workspace ........................................................................... 260
Consolidating Worksheets ......................................................................... 262 Consolidating by position................................................................. 263 Consolidating by category................................................................266 Linking consolidated data................................................................. 267