Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a cell
I need to have some cells add and delete in one column. At the end of each
day i need to clear everything out, but have the total at the bottom of the page appear at the top of the column. I have tried this, but when ever i hit the clear macro, it puts a zero at the top. Any idea how to lock that cell so it will not clear? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a cell
John
You have a formula in that cell at the top. That formula sums whatever is written in the formula. When you clear the cells that this formula sums, you will get the sum of those cells, zero. The only way to "freeze" that number is to remove the formula and replace it with the number that was displayed in that cell before you cleared the cells. To do this, select that cell (the one at the top that sums all the other cells). Do this before you clear the cells. Click on Edit - Copy. With that cell still selected click on Edit - Paste Special. Click on Values. Click OK. The formula is now gone and the number is still there. HTH Otto "John" wrote in message ... I need to have some cells add and delete in one column. At the end of each day i need to clear everything out, but have the total at the bottom of the page appear at the top of the column. I have tried this, but when ever i hit the clear macro, it puts a zero at the top. Any idea how to lock that cell so it will not clear? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell locking and program freezing | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |