/text/scalc/guide/database_sort.xhp database ranges; sorting sorting; database ranges data;sorting in databases Sorting Data Click in a database range. If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted. Choose Data - Sort. The range of cells that will get sorted is shown in inverted colors. Select the sort options that you want. Click OK.

Wiki page about defining a data range