Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List vs. Toggle Total Row
I have defined a list in Excel 2003, entered sample data in Row 1, and
selected "Toggle Total Row" to display sums/counts in the last row. I want to use these numbers as a reference for other formulas in the workbook. The problem I'm experiencing is that sometimes, after I close and reopen the workbook, the total row is appearing outside the defined list boundary, in the first row underneath the defined boundary. I have done nothing except save and close the file. If I select "Toggle Total Row" again, a new total row appears within the list boundary...and the rogue total row still remains outside the list! I am approaching a deadline at work, so any help anyone could provide would be greatly appreciated. I'm about ready to convert the list to a range just to meet deadline, but I really don't want to have to do that unless as a last resort. Thanks in advance for any help you can provide! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toggle total row | Excel Discussion (Misc queries) | |||
lock a total row below a list & allow inserting in the list? | Excel Worksheet Functions | |||
Data List - Total Row - Only displays "Total" | Excel Worksheet Functions | |||
"Toggle total row" button not enabled in Excel 2003 | Excel Discussion (Misc queries) | |||
look for one total from a list of numbers | Excel Discussion (Misc queries) |