To the point, anyone have any idea if instead of having all new sheets open side by side, if we can instead make 2 or 3 rows of sheets, stacked, so they can all be viewed without having to scroll right or left ?
Thanks
A table containing 30-40 rows takes a lot of place above the main table of a sheet.
Two possibilities:
Paul.
In Numbers a sheet (which you access by clicking a "tab" at the top) is a blank canvas on which you can place tables, charts, text boxes, and other items. You can place more than one table on a sheet if you want to view them at the same time.
SG
I really appreciate any time anyone gives for me, as it really is helpful. But I see I need to be more specific as Im new here. I need to have about 30-40 sheets, all with multiple tables on them. Thats no problem. However, as it is now, I can only view so many sheets, side by side, before I have to scroll the "sheet tabs" either left or right to view them all. I was wondering if the sheet tabs cant be stacked in rows, on top of each other, so that no scrolling ever has to be done. Again, EXTREMELY grateful to anyone that takes the time to reply.
Once you've made the TOC Sheet suggested by Paul, you might try this:
The TOC will actually be contained in a table on that sheet.
A copy of that table would likely work placed on any of the other sheets.
Consider laying out that table with the cells containing the links "stacked in rows, on top of each other, so that no scrolling ever has to be done," then placing a copy above the main table on each of the sheets.
Regards,
Barry
Note: I've not tested this, as I'm running an version of Numbers prior to the introduction of links that would move you to other sheets in the same document.
B.
You could make an additional "TOC" sheet: a Table of Contents with 30-40 rows. The first cell of each row could link to one of the 30-40 sheets.
Format > Add Link > Sheet.
Paul.
Thank You Barry!
Wonderful Idea and I will be doing this!
Nice suggestion!
Im sure after executing this, perhaps a single TOC cell in each sheet would be less clutter. Wonderful ideas from everyone that I would have never known about. Thank You!
Numbers New Sheets side by side
