Sorting of data in excel sheet

  • Thread starter Thread starter K Das
  • Start date Start date
K

K Das

Is it possible to lock a particular cell - which means
that even if the data is sorted, the data does not go to a
new cell, but remains in its cell for eg.

Cell A1 = 1
Cell A2 = 3
Cell A3 = 2

Now if I sort on column A, it would appear as follows:

Cell A1 = 1
Cell A2 = 2
Cell A3 = 3

Whereas I want it to appear as follows:

Cell A1 = 1
Cell A3 = 2
Cell A2 = 3

Something similar to filtering of data

Regards
 
Is it possible to lock a particular cell - which means
that even if the data is sorted, the data does not go to a
new cell, but remains in its cell
Click to expand...

It takes a little bit of gymnastics.

First, move the column of data to a different column, safely outside the
range you're sorting. (For instance, if the columns you sort are in A:G,
move the data to column J.)

Then in cells of the now-blank column, put
=index(J:J,row())

and fill down.

Now when you sort, and recalculate, the column will stay put.
 
Back
Top