Hello,
I am new to all database/spreadsheet programs. It is totally alien to me. I am trying to build a document to categorize and organise work and life. Essentially spreadsheet containing a few sheets that i can easily add to and modify - like a very basic database i guess - When i save it I want to essentially make a sort of clickable hierarchy of notes and tables. I can see that I can sort of do this by adding sheets to a shreadsheet, but as the document grows the line of sheets soon grows too and could become hard to navigate.
I was wondering if there is a way to put sheets within sheets? Is there another way to organise multiple sheets so that there is not one long line at the bottom of the screen? Can sheets be grouped perhaps? Are there other options for making this type of document like by using some sort of tabs or something? Is there anyway to add layers so to speak?
Or perhaps it is best to instead of one having one document, that I break it down into several , each containing their relevant sheets, but make a ‘front page’ document that links to them all? Is this possible? do all the documents need to be in the same folder? What is the best way to acheive my goal? Sorry i am very new to this. Ideally it will appear as one file that I need to open. I guess it doesn’t mater so much what happens in the background. Is Calc the correct program to use for this?
any help apreichated