ExcelBanter - Protected Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Protected Number (https://www.excelbanter.com/excel-discussion-misc-queries/136353-re-protected-number.html)

bigwheel

Protected Number

Until you can find it, you could copy the sum cell then Edit Paste
SpecialValues into another cell

"Steve" wrote:

After adding a number of cells, I want to delete the cells, but the sum
should remain and be used in other calculations. I am sure there is a one
button number in EXCEL, but I just cannot find it.
--
Steve

All times are GMT +1. The time now is 01:32 PM.