ExcelBanter - Move exact information in a row as you sort a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Move exact information in a row as you sort a column (https://www.excelbanter.com/excel-worksheet-functions/119431-move-exact-information-row-you-sort-column.html)

Michaela

Move exact information in a row as you sort a column

In a excel worksheet, Is it possible to move information in rows
automatically as accend sorting is being done? If so, how do I do it.?

Fred Smith

Move exact information in a row as you sort a column

Yes, just select the entire table before performing the sort. Or, make sure just
one cell is highlighted, then run the sort. Excel will include all adjacent
cells in the sort.

--
Regards,
Fred

"Michaela" wrote in message
...
In a excel worksheet, Is it possible to move information in rows
automatically as accend sorting is being done? If so, how do I do it.?

Michaela

Move exact information in a row as you sort a column

GREAT ANSWER.!! It did the job..!! Thank You

"Fred Smith" wrote:

Yes, just select the entire table before performing the sort. Or, make sure just
one cell is highlighted, then run the sort. Excel will include all adjacent
cells in the sort.

--
Regards,
Fred

"Michaela" wrote in message
...
In a excel worksheet, Is it possible to move information in rows
automatically as accend sorting is being done? If so, how do I do it.?

All times are GMT +1. The time now is 03:49 PM.