Ask Your Question

How can I sort particular column over a set of rows and apply that sequence to the other columns in my sheet only over those rows?

asked 2015-06-03 02:35:51 +0200

jughustler gravatar image

The sort gets applied to all rows and all columns. If I click on "extend to neighboring cells, it sorts each column separately,which makes the sort relatively useless. In Excell, you can select a range of rows to sort and apply that sequence to other selected columns

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-03 04:52:51 +0200

JKEngineer gravatar image

updated 2015-06-03 05:03:02 +0200

Select the rows in the columns you want to sort, either by drag selection or click and then shift click. In menu: Data>Sort, specify the column that controls. This will sort the selected region by the column specified.

before sorting, limited range selected

after sorting by col3 (C)

The images show the selected range before and after sorting.

EDIT: Actually rows 2-10 selected.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-03 02:35:51 +0200

Seen: 760 times

Last updated: Jun 03 '15