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