I need to change the order of a list as it is upside down. Is there a way of pasting cells in reverse order (column wise that is)?
Thanks in advance
I need to change the order of a list as it is upside down. Is there a way of pasting cells in reverse order (column wise that is)?
Thanks in advance
Assumming your list is in column A, put this in B1 and copy down to the extent of column A, then copy > paste Special > Values over column A. Then delete column B.
=OFFSET($A$1,COUNTA(A:A)-ROW(),0)
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks