Possible to reverse a row of entries?

  • Thread starter Thread starter rs
  • Start date Start date
R

rs

Is there a command or format command that will let me take a row of entries
and reverse them? In other words if I have rows #1 through #10 top to bottom,
I now want them to go #10 to #1 top to bottom.

thanks

Rick
 
Rick

You say "rows". More than one column in these rows?

Frank's formula assumes data in Column A only.

If multiple columns involved.........

Insert a column at left or right and enter 1 through 10 in that column.

Select all columns.

Data>Sort>Descending on the numbered column.

Gord Dibben Excel MVP
 
As an extension to Frank's suggestion
(there's a typo, missing "S" in OFFET),
assuming the original data is in Sheet1, in A1:E10
you could also try as just another option,

In Sheet2
------------
Put in A1: =OFFSET(Sheet1!$A$10,-(ROW(A1)-1),COLUMN(A1)-1)
Copy A1 across to E1, fill down to E10

Then select the original range in Sheet1,
click on the Format Painter icon to copy the format,
then just click on A1 in Sheet2 to paint the format over the inverted range
 
speaking of which, does anyone know why when i double click a cell in
pivot table to view where it got the info, it's always reversed?
like.. upside down
 
medicenpringles said:
speaking of which, does anyone know why when i double click a cell in a
pivot table to view where it got the info, it's always reversed?
like.. upside down?
Click to expand...

Not really, as some light testing might reveal
You'd probably get a mixed bag of results, which I did

But if one double-clicks on the *Grand Total number*,
the results seem to appear in the same order as in the source
 
Back
Top