How do I reverse the order in excel?



How do I reverse the order in excel?..

Answer / Kanchan Mala

To reverse the order of a range in Excel, follow these steps:
1. Select the range you want to reverse.
2. Copy the selection (Ctrl+C).
3. Right-click the destination cell and go to 'Paste Options'.
4. Choose 'Paste Special' -> 'Values' -> 'Text'.
5. After pasting, select the entire column or row and press F2 to enter edit mode.
6. Press Ctrl+Shift+Left Arrow (for horizontal data) or Ctrl+Shift+Up Arrow (for vertical data).
7. Press Enter to exit edit mode.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you use match in excel?

1 Answers  


What do you mean by cell in computer?

1 Answers  


Where is the data validation source in excel?

1 Answers  


Who built microsoft excel?

1 Answers  


How do you match and index in excel?

1 Answers  


How do I present data in excel?

1 Answers  


How do I allow one person to edit an excel spreadsheet at a time?

1 Answers  


I am trying to get the percentage of two cells by dividing one cell into the other. Some of the time both cells might have a zero in each. Therefore the div?

1 Answers  


How do I share an excel file between two computers?

1 Answers  


Why Does Excel Have Two Macro Languages?

1 Answers   Microsoft,


What is the definition of logical functions?

1 Answers  


What are function of ms excel?

1 Answers  


Categories