Q&A
| Q1: | I used the SUM function to subtotal a column of data in my database, and I don't want others to see some of the subtotals. What can I do? |
| A1: | You can hide each subtotal by collapsing it. Just click the minus sign (–) button for the subtotal on the far left side of the worksheet. |
| Q2: | Is there an easy way to delete the subtotals in my database? |
| A2: | Sure. Choose Data, Subtotal and click the Remove All button. |
| Q3: | I filtered my records with the Top 10 AutoFilter, and I didn't get the results I expected. What should I do? |
| A3: | You can either click the Undo button on the Standard toolbar or choose Data, Filter, Show All. This step displays all the records again. Then start over to choose the Top 10 AutoFilter options you want. |
| Q4: | How do I delete a ... |
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
