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 |
How do you use match in excel?
What do you mean by cell in computer?
Where is the data validation source in excel?
Who built microsoft excel?
How do you match and index in excel?
How do I present data in excel?
How do I allow one person to edit an excel spreadsheet at a time?
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?
How do I share an excel file between two computers?
Why Does Excel Have Two Macro Languages?
What is the definition of logical functions?
What are function of ms excel?