View Single Post
 
Old 07-19-2022, 01:50 PM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default Converting formulas from cell references to numbers

Is it possible in Excel to render a cell that shows, instead of cell references, the values within those cells? Like instead of the formula being =Q6+R6+S6+T6+U6, I could get a cell containing the contents, but within a formula (=5+4+0+2+10)?

A coworker suddenly wants every sheet to show a TYPED IN formula instead of the values, which I had calculated with an off-print-area helper column that summed the current and past to-date quantities. Copy/paste values, simple. She wants to see all the individual numbers, and it will take forever to update multiple sheets that way. I was just trying to figure out a workaround.
Reply With Quote