Sold Out
Book Categories |
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
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionTroubleshooting Microsoft Excel spreadsheets
X
This Item is in Your InventoryTroubleshooting Microsoft Excel spreadsheets
X
You must be logged in to review the productsX
X
X
Add Troubleshooting Microsoft Excel spreadsheets, 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 dia, Troubleshooting Microsoft Excel spreadsheets to the inventory that you are selling on WonderClubX
X
Add Troubleshooting Microsoft Excel spreadsheets, 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 dia, Troubleshooting Microsoft Excel spreadsheets to your collection on WonderClub |