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
Is there a way for me to list down all the sheet names of the document in a separate column or sheet?
→F5 still exists, and is available from everywhere in Calcdocuments!
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.
Done on LibreOffice 18.104.22.168 (x86); OS: Windows 6.1.