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.