Ask Your Question

Is there a way for me to list down all the sheet names of the document in a separate column or sheet?

asked 2016-05-26 04:57:17 +0100

jiraiyan21 gravatar image

updated 2020-07-09 01:20:29 +0100

LeroyG gravatar image

I have a file that has a lot of sheet names and would need the names listed in a single column of another sheet within the file to serve like its directory

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-07-09 01:20:06 +0100

LeroyG gravatar image

Choose menu View - Navigator (or just press F5), press on the Drag Mode icon (a world with chain links) and select Insert as Hyperlink, expand the Sheets category, then drag the sheet names one by one to the desired cells.

Sheet names to cells animation.

Done on LibreOffice (x86); OS: Windows 6.1.

edit flag offensive delete link more

answered 2016-05-26 06:24:32 +0100

karolus gravatar image


The Navigator →F5 still exists, and is available from everywhere in Calcdocuments!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-26 04:57:17 +0100

Seen: 672 times

Last updated: Jul 09 '20