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
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.
.
Done on LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.
hallo
The Navigator →F5
still exists, and is available from everywhere in Calcdocuments!