How to order cells in lane in excel?

1

It is very easy to order cell values in column, but how can I order many values in a lane?

I would like to avoid to

  1. copy
  2. paste/trasponse
  3. order
  4. copy
  5. paste/trasponse

Ale

Posted 2016-04-14T14:30:16.877

Reputation: 704

Answers

1

In the Home tab - editing, open Sort & Filter and select custom sort.

enter image description here
Select options and chose Sort Left to Right

This may vary to Office versions, but the steps are similar.
If you give me your version of Office, I will update my answer with the steps accordingly.

Divin3

Posted 2016-04-14T14:30:16.877

Reputation: 1 568

I use Office 2007 and I find where to set this options – Ale – 2016-04-14T16:04:14.307