 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Locking 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? 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 >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 [quoted text clipped - 4 lines] > cell > so it will not clear? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.