Ask Your Question

Calc - sorting data on multiple sheets [closed]

asked 2012-12-02 03:05:23 +0200

jonyd1 gravatar image

Hi everyone - I was wondering if it's possible to sort data on multiple sheets. I'm trying to alphabetize the first column of multiple sheets, so I select all the sheets I want (they all have the same data in that first column - a list of names), then select the data I want to sort, then go to Data->Sort, and click ok. Calc then alphabetizes the data I selected, but only on the current sheet.

Is it possible to have all the selected sheets alphabetized? Thanks very much!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 03:16:20.211433

2 Answers

Sort by » oldest newest most voted

answered 2012-12-02 09:14:32 +0200

Jean-Baptiste FAURE gravatar image

AFAIK it is not possible. If you want alphabetical sort through several sheets, the method I suggest is to work on a synthetic sheet which collect data in each sheet to sort using formula like = sheet1.A1. Then sort this synthetic sheet.

edit flag offensive delete link more


That worked perfectly - also made it easier to update the spreadsheet later on - thanks!!

jonyd1 gravatar imagejonyd1 ( 2012-12-02 18:25:41 +0200 )edit

sample how to do this pls

josh gravatar imagejosh ( 2018-01-07 03:10:39 +0200 )edit

answered 2012-12-02 09:27:48 +0200

ROSt52 gravatar image

I don't know why you have more than 1 sheet (sheet has 1 mio rows). With as many data set I assume you have, I would rather take the effort and go into Base.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-12-02 03:05:23 +0200

Seen: 943 times

Last updated: Dec 02 '12