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