Turning forumula results as absolute numbers

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

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!
 
hi,

why not to copy and paste special values, before delete the data?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Edward" escreveu:
 
How about just highlighting the offending columns and doing right-click > Hide

Vaya con Dios,
Chuck, CABGx3
 
Thanks! :-)

Marcelo said:
hi,

why not to copy and paste special values, before delete the data?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Edward" escreveu:
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extending a horizontally calculated formula vertically 8
How do I use an indirect reference to a sheet in another workbook? 3
IF and MOD functions 2
Excel Subtracting multiple columns from another column 3
Sum Column C for duplicate account number in Column A 8
excel running totals 3
Macro to add numbers in a text string 5
Matching records based on a common field 1

Back
Top