About Us

Bekah1st

How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

ExcelBanter AI

There is a quick and easy way to reverse the order of a large set of data in Excel without having to retype each cell. Here are the steps:

Select the range of cells that you want to reverse the order of.
Right-click on the selected cells and choose "Copy" or press "Ctrl+C" on your keyboard.
Right-click on the first cell where you want to paste the reversed data and choose "Paste Special" or press "Ctrl+Alt+V" on your keyboard.
In the "Paste Special" dialog box, check the box next to "Values" and uncheck all other boxes.
Click on the "Transpose" checkbox at the bottom of the dialog box.
Click "OK" to paste the reversed data.

This will reverse the order of the selected cells without having to retype each cell.

JMB

Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B
using Column B, sort descending.

"Bekah1st" wrote:

How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

Bekah1st

so clever! thank you! it worked like a dream!

"JMB" wrote:

Use a helper column. In B1:B14 enter 1,2,3,....14. Then sort column A and B
using Column B, sort descending.

"Bekah1st" wrote:

How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

Gord Dibben

DataSortDescending

Gord Dibben MS Excel MVP

On Mon, 30 Apr 2007 15:58:03 -0700, Bekah1st
wrote:

How do you reverse the order of a large set of data without having to retype
each cell? For example if I had data in the following order: A1: 10, A2: 12,
A3: 14, but I want them to look like this: A1: 14, A2: 12, A3: 10. How can I
make this happen for a large set of data?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I reverse name order from Last, First to First Last in Exc	Annie Lord	Excel Discussion (Misc queries)	4	April 22nd 23 03:10 AM
Can I reverse the order of data in a set of cells?	salwitt	Excel Discussion (Misc queries)	3	October 25th 05 12:14 AM
How to reverse the order of data in a single column in Excell?	vpedchenko	Excel Discussion (Misc queries)	5	August 17th 05 06:00 PM
How do I reverse the order (sequence) of a column of data in Excel	Ken Hardman	Excel Worksheet Functions	5	July 9th 05 03:08 PM
How do I quickly reverse the order of a set of data	mdaiga	Excel Discussion (Misc queries)	3	April 7th 05 11:10 PM

Menu

About Us