Sorting help

users
#1

I am moving from Excel to Calc......and trying to sort a column...

In Excel, I can select a column, then, prior to the sort can tell excel to include the entire row data to 'move' along with the data in the column.

How do I do that in Libre Office?

TIA

lyle

#2

I'm not quite sure what you're asking, but...

If you're trying to sort entire rows by the value in a single column, you need to select the rows. When you go to the sort menu, simply select the column you want as your sort key. You might have to go to the Options tab to indicate whether or not your data selection includes a header row; like in Excel, how this comes up seems to be completely random (in other words, I've never discerned a pattern to how it works).

If I'm misunderstanding your question, please try again!

Dave

#3

Select any single cell in the column you want to sort by and click a
sort button [A-Z] or [Z-A].
The selection will expand to the so called current region which is the
area of adjacent non-empty cells.

#4

This problem has been solved - thanks to all who responded.