View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
edward edward is offline
external usenet poster
 
Posts: 87
Default Turning forumula results as absolute numbers

I have about 290 text boxes (list) on the left side of the worksheet numbered
sequestionally. Just like a list. I have tabulated data across the page
(left to right) using a formula to sum the columns across the page for each
of the 290 items. What I would like to do is to eliminate the columns now
but retain the totals for each of the 290 items in order to use as a table
for my dissertation.

Is it possible to "turn-off" the formulas so that when I delete the columns
(between list and totals), my totals don't go away? I would hate to retype
each of the numbers total for each item - not to mention how tedious that is
but also chance for more human error. Any help is appreciated.

Thanks!