Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I lock a cell to a row?
Excel 2007
Windows Vista Premium I am tallying up a list of expenses and I want the TOTAL to be at a specific line at the bottom of the page (Row 45) even after I add some items and their rows to the list above it. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I lock a cell to a row?
You may be able to play around with event macros to get something that works for
you. But I wouldn't do it. Instead, I'd put my totals in row 1, my headers for the data in row 2 and the data in rows 3-###. In fact, I'd use =subtotal() as my formulas to determine the totals. Then I could apply data|filter|autofilter to the headers and data and those =subtotal() will ignore the hidden rows when they evaluate. Steve wrote: Excel 2007 Windows Vista Premium I am tallying up a list of expenses and I want the TOTAL to be at a specific line at the bottom of the page (Row 45) even after I add some items and their rows to the list above it. Is this possible? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I lock a cell to a row?
As long as you don't physically insert/delete rows, yes. If you need to copy
entries to put into rows on the sheet. Use copy and Paste Special with the "Values" option selected to add data to rows without actually inserting a new row. "Steve" wrote: Excel 2007 Windows Vista Premium I am tallying up a list of expenses and I want the TOTAL to be at a specific line at the bottom of the page (Row 45) even after I add some items and their rows to the list above it. Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I lock a cell to a row?
Thank you both, JLatham and Dave.
I see that I am not going to be able to do this the way I originally envisioned. Excellent suggestions for ways to work around it, though. Thanks. "Dave Peterson" wrote: You may be able to play around with event macros to get something that works for you. But I wouldn't do it. Instead, I'd put my totals in row 1, my headers for the data in row 2 and the data in rows 3-###. In fact, I'd use =subtotal() as my formulas to determine the totals. Then I could apply data|filter|autofilter to the headers and data and those =subtotal() will ignore the hidden rows when they evaluate. Steve wrote: Excel 2007 Windows Vista Premium I am tallying up a list of expenses and I want the TOTAL to be at a specific line at the bottom of the page (Row 45) even after I add some items and their rows to the list above it. Is this possible? -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions |