Sorting Sheets in Calc

users
#1

Hi,
   I have a spreadsheet with about 30 tabs (sheets). I want to re-arrange
these. Is there a way to display the list and sort them as I wish without
having to drag each sheet to a new position? I know that excell has the
ability to display the sheets in a list form and one can highlight one of
these and "Move Up" or "Move Down". This would be very useful.

Paddy

#2

Sort of. Go to Edit | Sheet > | Move/Copy... (or right-click the sheet tab and select Move/Copy Sheet...). But you can move only one sheet at a time there.

Is your problem with dragging that you cannot see all thirty (no doubt meaningfully labelled) sheet tabs at the same time? Note that you can drag the separator between the tab display and the horizontal scroll bar to make more room for the former - perhaps temporarily. When you can see all thirty tabs at once, dragging may seem more attractive.

I trust this helps.

Brian Barker

#3

This does raise an interesting question.

Should TABS have a sort mechanism default.
Un-Sorted with the addition of Alphabetical, by creation date, etc...

#4

Hi :slight_smile:
I think it would be a good "feature request". I've never heard of anyone
needing anything like this before. Generally it's a good idea to keep the
number of work-sheets down to a manageable amount but being able to sort
tabs could easily become a much sought-after (sorry i was trying really
hard to get that in!) function.
Regards from
Tom :slight_smile: