Troubleshooting Microsoft Excel spreadsheets Book

Acknowledgments  Page xi
About this book  Page xiii
Troubleshooting tips  Page xv
Charts  Page 2
    My chart includes data I don’t want  Page 4
    My chart doesn’t change when I update my worksheet  Page 6
    I’ve resized my chart, and now it looks jumbled  Page 8
    My chart doesn’t look the way I expect when I print my worksheet  Page 10
    It’s hard to see what all this data means  Page 12
Columns and rows  Page 14
    I adjusted my row heights, and now my new entries don’t fit  Page 16
    Some of my columns and rows are out of order  Page 18
    I hid some of my columns, and now I can’t get them back  Page 20
    Rows are missing from my worksheet  Page 22
Comments and Track Changes  Page 24
    Comments and track-change comments pop up on the screen, and I don’t want them to  Page 26
    I don’t want my name to appear in the comment box  Page 28
    Other people make changes to my worksheet, and I want to keep track of those changes  Page 30
    I don’t want to keep some of the changes made since Track Changes was turned on  Page 32
Conditional formatting  Page 34
    I’m not sure how to set up conditional formatting  Page 36
    I don’t know how to set up multiple conditions  Page 38
    I applied conditional formatting, but it didn’t work  Page 40
    The conditional formats I set up aren’t updated when I edit my worksheet  Page 42
    I’m not sure how to change my conditional formats  Page 44
Currency  Page 46
    I clicked the Currency Style button, but now I wish I hadn’t  Page 48
    I have no euro currency formatting button on my toolbar  Page 50
    When I press Enter, the number I typed changes  Page 52
    I’m not sure how to format my numbers as foreign currency  Page 54
Dates  Page 56
    When I enter a date, a number I don’t recognize appears in the cell instead  Page 58
    The month and day I entered appear transposed in the date  Page 60
    The date format I need isn’t provided by Excel  Page 62
    When I put Excel content into an Access database, I have trouble with cells formatted as dates  Page 64
Drawing shapes and lines  Page 66
    The Group command isn’t available on the Draw menu  Page 68
    When I move my AutoShape, it changes size  Page 70
    My callouts aren’t pointing to the right items  Page 72
    I typed text into an AutoShape, and some of it is hidden  Page 74
    I rotated my shape, but its text didn’t rotate with it  Page 76
Entering data  Page 78
    When I type in the active cell, nothing happens  Page 80
    Text that I typed in a cell looks cut off by adjoining cells  Page 82
    I’m tired of entering the same series of labels in my worksheets  Page 84
    I can’t get my data validation rules to work  Page 86
Exporting and importing  Page 88
    The object type I want isn’t listed in the Object dialog box  Page 90
    When I paste a Word table into my worksheet, the table’s content appears in the wrong cells  Page 92
    When I paste Excel cells into a Word table, the content appears in the wrong cells  Page 94
    The chart I pasted into a Word document doesn’t change when I update the Excel data  Page 98
    When I paste Excel data into an Access table, column headings appear as the first record  Page 102
Filtering records  Page 104
    When I filter my list, all of my records disappear  Page 106
    I don’t see my filter criteria in the AutoFilter list  Page 108
    I don’t know how to find and fix errors and inconsistencies in my data  Page 110
    The advanced filter I applied didn’t work  Page 112
Formatting numbers  Page 114
    When I type a decimal ending in zero, the zero disappears  Page 116
    I typed a number, but it’s not right-aligned  Page 118
    The fractions I entered aren’t displayed correctly  Page 120
    None of the available number formats meet my needs  Page 122
Formatting text  Page 124
    My worksheet text is too small to read  Page 126
    The format of my text isn’t consistent throughout my worksheet  Page 128
    I’m not sure how to format paragraph text in my worksheet  Page 130
    I can’t center a title across the top row of my worksheet  Page 132
    People keep changing my text formatting, and I don’t want them to  Page 134
Formatting worksheets  Page 136
    When I move a cell’s content, the formatting comes with it  Page 138
    I can’t control how the AutoFormat command is applied  Page 140
    I don’t want to have to build identical worksheets individually  Page 142
    The Background command is unavailable  Page 144
Formulas  Page 146
    My formula causes an error message to appear  Page 148
    When I test my formula on a calculator, I get a different answer  Page 150
    When I edit the cells referenced in my formula, the result doesn’t change  Page 152
    The results of my summary worksheet formulas are incorrect  Page 156
Functions  Page 158
    I don’t know how to construct the function I need  Page 160
    I don’t know what to include in this function  Page 162
    I get an error message when I enter my function   Page 164
    Cells I need to include in my function aren’t in my active worksheet   Page 166
    I’m not sure how to combine two functions in one formula  Page 168
Hyperlinks  Page 170
    I’m not sure how to link to a spot in my current workbook  Page 172
    I don’t know the exact web address that my hyperlink should point to  Page 174
    I click a hyperlink in my worksheet, and nothing happens  Page 176
    When I click my hyperlink, it creates a new, blank workbook  Page 178
Macros  Page 180
    My macro won’t run in the active workbook  Page 182
    My macro doesn’t work at all  Page 184
    I made an error while recording my macro  Page 186
    I don’t know how to delete macros I no longer need  Page 188
Maps  Page 190
    I’m not sure how to get data from my worksheet to appear on a map  Page 192
    I don’t know how to add roads and cities to my map  Page 194
    My map labels are hard to read  Page 196
    I resized my map, and now the content of the map has changed  Page 198
Naming cells  Page 200
    It’s taking too long to find cells in my worksheet  Page 202
    I’m not sure how to apply a name to a range of cells  Page 204
    I don’t know how to turn column and row labels into names  Page 206
    It takes too long to name the same cells in all my worksheets  Page 208
Outlining  Page 210
    I’m not sure if my worksheet can be turned into an outline  Page 212
    When I use the Auto Outline command, I get an error message  Page 214
    When I copy summary data to another worksheet, the details are copied too  Page 216
    My worksheet content doesn’t fall into appropriate outline groups  Page 218
PivotTables  Page 220
    I made mistakes setting up my PivotTable, but I don’t want to start over from scratch  Page 222
    My data includes blank fields, but they’re not showing up in my PivotTable  Page 226
    I double-clicked a cell in my PivotTable, and a new sheet was added to my workbook  Page 228
    I refreshed my PivotTable, but the data still doesn’t reflect my changes  Page 230
    I don’t want to have to re-create my PivotTable for use with other data  Page 232
Printing  Page 234
    I can’t print my whole worksheet on a single page  Page 236
    I can print only part of my worksheet, but I want to print all of it  Page 238
    My column and row labels don’t appear on every page of my printout  Page 240
    It takes too long to open and print all of my workbooks one at a time  Page 242
Saving  Page 244
    I can’t save my workbook  Page 246
    I’m tired of changing folders every time I save a new workbook  Page 248
    I can’t find my workbook  Page 250
    I can’t save my workbook in HTML format  Page 252
Searching for data  Page 256
    I have a very large database, and I can’t find one of my records  Page 258
    When I use the Find command, I get an error message  Page 260
    I used Replace All, and now I wish I hadn’t  Page 262
    The Find command doesn’t allow me to search by example  Page 264
Sorting data  Page 266
    I’m not sure how to sort my database by more than one field  Page 268
    The sort I applied didn’t work as I expected  Page 270
    My column labels don’t appear in the Sort dialog box  Page 272
    I didn’t set up my database properly, and now I can’t sort it  Page 274
Spelling  Page 276
    The spelling checker isn’t catching all of my spelling errors  Page 278
    I’m not sure how to check the spelling of foreign words  Page 280
    I have a lot of complex terms in my worksheet, and I’m tired of typing them  Page 282
Subtotal reports  Page 284
    When I click the Subtotals command, I get an error message  Page 286
    My subtotals are in the wrong places  Page 288
    The wrong function is applied to my subtotaled records  Page 290
Templates  Page 292
    I don’t want to keep creating the same workbook over and over  Page 294
    My template doesn’t appear in the New dialog box  Page 298
    My template includes data from other workbooks, but that data is missing now  Page 300
    I’m tired of inserting my logo every time I use the Invoice template  Page 302
Workspace customization  Page 304
    Every time I open Excel, the Formatting toolbar is missing  Page 306
    The toolbars don’t have all the buttons that I want  Page 308
    All of my workbooks should start with four blank worksheets, not three  Page 310
    The gridlines on my worksheet are too dark  Page 312
INDEX  Page 315