Hi Arda,
Am 18.01.2011 11:08, schrieb Arda Tunccekic:
I have a dataset like this. There are empty rows.
Is there a way to sort these values by choosing the first column?
(1) Select the whole range from 90 on the top left to g on the
bottom right, including the empty cells.
(2) Use the
Thank you, it works. :)
I wish it could also be done by clicking on Column A and clicking on the
Sort Icon (simpler)
On 18.01.2011 12:30, Stefan Weigel wrote:
Hi Arda,
Am 18.01.2011 11:08, schrieb Arda Tunccekic:
I have a dataset like this. There are empty rows.
Is there a way to sort
Hi Arda,
Am 18.01.2011 12:21, schrieb Arda Tunccekic:
I wish it could also be done by clicking on Column A and clicking on
the Sort Icon (simpler)
No, not simpler, because when you click on column A, how should your
Computer know, that you do not want to sort only the values in
column A, but
Hi :)
The problem is that sometimes you might want to sort Column A independently of
the other columns but at other times you want the whole worksheet to get sorted
keeping the rows or record's fields together.
Excel has made a mistake in trying to muddle those 2 separate functions
together
Hallo Sigrid,
Am 18.01.2011 12:56, schrieb Sigrid Carrera:
*It only sorts the column that is highlighted* the rest of the other columns
stay as they are.
I know what you mean. But since some time, in this case Calc shows a
special Dialog asking the user, if he really means, what he is
doing.
Yeh, if you want all the columns sorted then it is best to open with Base
instead of Calc. It sounds as though your spreadsheet is now really a database
and needs database functionality instead of spreadsheet functionality. Don't
panic! It is quite easy to use!
Alternatively in Calc just