Tjyylli

How to install OpenCV on Raspbian Stretch?

Would a completely good Muggle be able to use a wand?

What did we know about the Kessel run before the prequels?

If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?

Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?

How to count occurrences of text in a file?

When you upcast Blindness/Deafness, do all targets suffer the same effect?

What is the value of α and β in a triangle?

Do I need to write [sic] when a number is less than 10 but isn't written out?

Why do airplanes bank sharply to the right after air-to-air refueling?

I want to delete every two lines after 3rd lines in file contain very large number of lines :

Is there always a complete, orthogonal set of unitary matrices?

Should I cite using begin{thebibliography} or begin{filecontents*}

Is micro rebar a better way to reinforce concrete than rebar?

Are police here, aren't itthey?

Why doesn't UK go for the same deal Japan has with EU to resolve Brexit?

What steps are necessary to read a Modern SSD in Medieval Europe?

Find non-case sensitive string in a mixed list of elements?

What connection does MS Office have to Netscape Navigator?

Is wanting to ask what to write an indication that you need to change your story?

Axiom Schema vs Axiom

Prepend last line of stdin to entire stdin

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

Why does the flight controls check come before arming the autobrake on the A320?

Reverse order of rows in Excel

34

4

Is there any simple way to reverse the order of some rows in Excel? I'd rather hoped that there might be a suitable option in Paste Special, as there is for Transpose, but apparently not.

microsoft-excel

share|improve this question

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

add a comment | 

34

4

Is there any simple way to reverse the order of some rows in Excel? I'd rather hoped that there might be a suitable option in Paste Special, as there is for Transpose, but apparently not.

microsoft-excel

share|improve this question

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

add a comment | 

Is there any simple way to reverse the order of some rows in Excel? I'd rather hoped that there might be a suitable option in Paste Special, as there is for Transpose, but apparently not.

microsoft-excel

share|improve this question

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

share|improve this question

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

share|improve this question

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

asked Aug 24 '09 at 14:42

stevemegsonstevemegson

283146

4 Answers
4

active

oldest

votes

38

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

To expand on DLux' answer:

Instead of manually adding the 1, 2, 3, 4, you can:

1) Enter 1 on the first row, then a 2 on the cell directly below it

2) Select both cells

3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign.

4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically.

This'll save you some time if you've got a large number of rows to reverse.

share|improve this answer

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I assume that's what DLux meant. Most people know that you can drag the box to continue sequences/patterns.
  
  – DisgruntledGoat
  Aug 24 '09 at 15:00
  

  
  
  
  


• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  There speaks a man who doesn't do user support.
  
  – Col
  Aug 24 '09 at 15:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I like this explanation, no matter i already know how to do it, maybe stevemegson does not.
  
  – Jhonny D. Cano -Leftware-
  Aug 24 '09 at 15:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  (By the way, this answer was supposed to be a comment on DLux' answer. But, since I'm new here, I couldn't comment yet. Argh.)
  
  – CaptainKeytar
  Aug 24 '09 at 15:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've accepted this one because it's more complete for someone finding this question later (though I did know the extra bit). CaptainKeytar, if you feel all guilty about stealing DLux's rep, you can always add the comment when you have enough rep and I'll accept DLux's answer instead :)
  
  – stevemegson
  Aug 24 '09 at 15:42
  

  
  
  
  

 | 
show 1 more comment

29

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

share|improve this answer

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  To expand on DLux' answer: Instead of manually adding the 1, 2, 3, 4, you can: 1) Enter 1 on the first row, then a 2 on the cell directly below it 2) Select both cells 3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign. 4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically. This'll save you some time if you've got a large number of rows to reverse.
  
  – CaptainKeytar
  Aug 27 '09 at 20:31
  

  
  
  
  

add a comment | 

3

A simple way to reverse the order of a row or a column:

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 – like transposing, but 180 degrees instead of 90. To reverse a row use this:

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

The range to be reversed is I4:L4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

To reverse the order of elements in a column you have:

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

Now you see that the first row element is not anchored so the row count will decrease as the cell is copied down.

share|improve this answer

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

add a comment | 

-1

Been diagnosed with multiple sclerosis in 2015, and I was a woman of 50. They put me on Rebif which I took until 2017 and was switched to Copaxone. I had two relapses on Rebif, none so far on Copaxone. I do notice my balance was getting worse, and my memory, as well as erectile dysfunction and spasms’ had no choice to sick for other solution and I was introduce to totalcureherbalfoundation gmailcom which I purchase the MS herbal formula from the foundation, the herbal supplement has effectively get rid of my multiple sclerosis and reversed all symptoms. 

share

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f28813%2freverse-order-of-rows-in-excel%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

38

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

To expand on DLux' answer:

Instead of manually adding the 1, 2, 3, 4, you can:

1) Enter 1 on the first row, then a 2 on the cell directly below it

2) Select both cells

3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign.

4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically.

This'll save you some time if you've got a large number of rows to reverse.

share|improve this answer

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I assume that's what DLux meant. Most people know that you can drag the box to continue sequences/patterns.
  
  – DisgruntledGoat
  Aug 24 '09 at 15:00
  

  
  
  
  


• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  There speaks a man who doesn't do user support.
  
  – Col
  Aug 24 '09 at 15:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I like this explanation, no matter i already know how to do it, maybe stevemegson does not.
  
  – Jhonny D. Cano -Leftware-
  Aug 24 '09 at 15:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  (By the way, this answer was supposed to be a comment on DLux' answer. But, since I'm new here, I couldn't comment yet. Argh.)
  
  – CaptainKeytar
  Aug 24 '09 at 15:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've accepted this one because it's more complete for someone finding this question later (though I did know the extra bit). CaptainKeytar, if you feel all guilty about stealing DLux's rep, you can always add the comment when you have enough rep and I'll accept DLux's answer instead :)
  
  – stevemegson
  Aug 24 '09 at 15:42
  

  
  
  
  

 | 
show 1 more comment

38

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

To expand on DLux' answer:

Instead of manually adding the 1, 2, 3, 4, you can:

1) Enter 1 on the first row, then a 2 on the cell directly below it

2) Select both cells

3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign.

4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically.

This'll save you some time if you've got a large number of rows to reverse.

share|improve this answer

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  I assume that's what DLux meant. Most people know that you can drag the box to continue sequences/patterns.
  
  – DisgruntledGoat
  Aug 24 '09 at 15:00
  

  
  
  
  


• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  There speaks a man who doesn't do user support.
  
  – Col
  Aug 24 '09 at 15:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I like this explanation, no matter i already know how to do it, maybe stevemegson does not.
  
  – Jhonny D. Cano -Leftware-
  Aug 24 '09 at 15:11
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  (By the way, this answer was supposed to be a comment on DLux' answer. But, since I'm new here, I couldn't comment yet. Argh.)
  
  – CaptainKeytar
  Aug 24 '09 at 15:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've accepted this one because it's more complete for someone finding this question later (though I did know the extra bit). CaptainKeytar, if you feel all guilty about stealing DLux's rep, you can always add the comment when you have enough rep and I'll accept DLux's answer instead :)
  
  – stevemegson
  Aug 24 '09 at 15:42
  

  
  
  
  

 | 
show 1 more comment

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

To expand on DLux' answer:

Instead of manually adding the 1, 2, 3, 4, you can:

1) Enter 1 on the first row, then a 2 on the cell directly below it

2) Select both cells

3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign.

4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically.

This'll save you some time if you've got a large number of rows to reverse.

share|improve this answer

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

share|improve this answer

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

answered Aug 24 '09 at 14:51

CaptainKeytarCaptainKeytar

78446

29

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

share|improve this answer

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  To expand on DLux' answer: Instead of manually adding the 1, 2, 3, 4, you can: 1) Enter 1 on the first row, then a 2 on the cell directly below it 2) Select both cells 3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign. 4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically. This'll save you some time if you've got a large number of rows to reverse.
  
  – CaptainKeytar
  Aug 27 '09 at 20:31
  

  
  
  
  

add a comment | 

29

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

share|improve this answer

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  To expand on DLux' answer: Instead of manually adding the 1, 2, 3, 4, you can: 1) Enter 1 on the first row, then a 2 on the cell directly below it 2) Select both cells 3) Move your mouse cursor to the bottom right corner of the cell that contains the "2". The cursor should change into a + sign. 4) Click and drag downwards. Excel will fill in the cells you drag over, and increment the values automatically. This'll save you some time if you've got a large number of rows to reverse.
  
  – CaptainKeytar
  Aug 27 '09 at 20:31
  

  
  
  
  

add a comment | 

Insert a column A, then put a counter in that row (1, 2, 3, 4). Then sort the spreadsheet on column A in descending order.

share|improve this answer

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

share|improve this answer

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

answered Aug 24 '09 at 14:45

dluxdlux

3,15872630

3

A simple way to reverse the order of a row or a column:

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 – like transposing, but 180 degrees instead of 90. To reverse a row use this:

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

The range to be reversed is I4:L4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

To reverse the order of elements in a column you have:

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

Now you see that the first row element is not anchored so the row count will decrease as the cell is copied down.

share|improve this answer

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

add a comment | 

3

A simple way to reverse the order of a row or a column:

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 – like transposing, but 180 degrees instead of 90. To reverse a row use this:

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

The range to be reversed is I4:L4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

To reverse the order of elements in a column you have:

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

Now you see that the first row element is not anchored so the row count will decrease as the cell is copied down.

share|improve this answer

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

add a comment | 

A simple way to reverse the order of a row or a column:

If you have row elements of 1,2,3,4 then you want them to be in a row, but in the order 4,3,2,1 – like transposing, but 180 degrees instead of 90. To reverse a row use this:

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

The range to be reversed is I4:L4. Note that the first column in the count is not anchored so this value gets walked down from 4 to 3 to 2 to 1 as you copy the cell to the right.

To reverse the order of elements in a column you have:

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

Now you see that the first row element is not anchored so the row count will decrease as the cell is copied down.

share|improve this answer

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

=INDEX($I$4:$L$4,1,COUNT(I$4:$L$4))

=INDEX($I$4:$I$8,COUNT($I4:$I$8),1)

share|improve this answer

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

edited Feb 29 '12 at 10:14

slhck

163k47449473

edited Feb 29 '12 at 10:14

slhck

163k47449473

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

answered Feb 29 '12 at 2:28

trgraneytrgraney

311

-1

Been diagnosed with multiple sclerosis in 2015, and I was a woman of 50. They put me on Rebif which I took until 2017 and was switched to Copaxone. I had two relapses on Rebif, none so far on Copaxone. I do notice my balance was getting worse, and my memory, as well as erectile dysfunction and spasms’ had no choice to sick for other solution and I was introduce to totalcureherbalfoundation gmailcom which I purchase the MS herbal formula from the foundation, the herbal supplement has effectively get rid of my multiple sclerosis and reversed all symptoms. 

share

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

-1

Been diagnosed with multiple sclerosis in 2015, and I was a woman of 50. They put me on Rebif which I took until 2017 and was switched to Copaxone. I had two relapses on Rebif, none so far on Copaxone. I do notice my balance was getting worse, and my memory, as well as erectile dysfunction and spasms’ had no choice to sick for other solution and I was introduce to totalcureherbalfoundation gmailcom which I purchase the MS herbal formula from the foundation, the herbal supplement has effectively get rid of my multiple sclerosis and reversed all symptoms. 

share

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Been diagnosed with multiple sclerosis in 2015, and I was a woman of 50. They put me on Rebif which I took until 2017 and was switched to Copaxone. I had two relapses on Rebif, none so far on Copaxone. I do notice my balance was getting worse, and my memory, as well as erectile dysfunction and spasms’ had no choice to sick for other solution and I was introduce to totalcureherbalfoundation gmailcom which I purchase the MS herbal formula from the foundation, the herbal supplement has effectively get rid of my multiple sclerosis and reversed all symptoms. 

share

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 5 mins ago

Finlay CedarFinlay Cedar

1

New contributor

Finlay Cedar is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 5 mins ago

Finlay CedarFinlay Cedar

1