List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a list that sorts multiple columns with formulas in them. I am
trying to eliminate get rid of blank cells and numerically sort the cells
using a list. My problem is I can't unsort the list after sorting if
necessary. In some cases I may need to put the formulas back in their
correct cells in order to add more data. How can I put the values back in
their original cells before sorting them? Any help would be appreciated.
Thanks.
 
What you are describing is very frustrating. What I do is to insert a help
column containing 1,2,3,4,.... down the column. I sort this column along
with the others. If I ever want to go back to the original order, I sort by
the helper column to get back to 1,2,3,4,...

The only alternative I have found to to start pumping the un-do button and
pray.
 
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

Sorting day names chronologically 5
refresh? 2
Auto sort help. 2
Sorting table of numbers with different place values 3
sorting in excel 2003 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
avoid Descending Sort putting error cells uppermost in collumn 3
#value error for sumproduct using RIGHT cmd 0

Back
Top