| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Totals in my filtered worksheet
I have a large worksheet that is filtered. At the bottom of the worksheet I
have totals for some of the columns. When I filter on a column the totals disappear. This just started happening. What have I done???? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Totals in my filtered worksheet
Do you mean the rows with the totals (or Subtotals) are hidden?
If yes, then that row is part of the autofilter range. Maybe you can leave an empty row between the data and the total/subtotal row. Personally, I like to put the total/subtotals in row 1, headers in row 2 and data in rows 3:xxxx. dml29 wrote: I have a large worksheet that is filtered. At the bottom of the worksheet I have totals for some of the columns. When I filter on a column the totals disappear. This just started happening. What have I done???? Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas, for filtered worksheet | Excel Discussion (Misc queries) | |||
| numbering rows in a filtered worksheet | Excel Worksheet Functions | |||
| Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
| Totals for filtered data | Excel Discussion (Misc queries) | |||
| How do I save a filtered subset of a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
