Transpose

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Is there a way in Excel to reverse the way rows are
displayed? For examle: A row has numbers going from left
to right 123456789 with each number in a seperate cell to
987654321. I want to somehow reverse the way they are
going.
 
You can sort a row just as you can sort a column.

Insert a new row above or below the row in question and number it
consecutively.
Select both rows and:
<Data> <Sort> <Options>,
And check "SortLeftToRight", then <OK>,
Check the proper row number and choose ascending or descending, depending on
your numbering pattern, and <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way in Excel to reverse the way rows are
displayed? For examle: A row has numbers going from left
to right 123456789 with each number in a seperate cell to
987654321. I want to somehow reverse the way they are
going.
 
Back
Top