Answer Posted / 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 View All Answers
Please Help Members By Posting Answers For Below Questions
