Johnny,

Unhide rows 4-5

Insert a 1 in A4, and Ctrl/+drag this to A31 to number the rows.
(that is, hold CTRL and drag the + sign in the bottom right corner of
the selected A6)
Select rows 4 to 31, Data, Sort, sort descending

then - unhide columns D - AE

Insert a 1 in D1 and Ctrl/+drag to AE1 to number the columns
select columns D to AE and Data, Sort, Options (select Left ro Right),
and sort descending

Clear A1 to A31 and D1 to AE1

that should give what you seek.


Johnny Wrote:
September 10, 2005

Hello, all,

I've made a big boo-boo in an Excel 2000 spreadsheet, and I can't
figure
out how to fix it. Can you help?

I've created a table with 28 rows and 28 columns, and I've
painstakingly
typed data into many of the resulting 784 cells. Only now do I
realize
that the order of the columns is reversed, i.e., what was ABCD needs
to
be DCBA. Same with the 28 rows, which have slightly different names.

You can see the table as it is now by opening or downloading it from
http://barelybad.com/eraseme_excel_test01.xls.

As you can see, the columns run from Noland to Ridgeview, and I'd like
them to run from Ridgeview to Noland. Again, same with the rows.

My question is how to accomplish a one-time re-ordering of the columns
and the rows while, of course, keeping the data where they belong. Is
there a way to do this?

Thanks for any help you can offer, and the more detailed the better,
because I'm not all that familiar with Excel.

--Johnny
barelybad aattsiggnn h o t m a i l --dot-- c o m


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=466559