Emma has attended:
Dreamweaver Introduction (1 day) course
Photoshop Introduction course
Excel Intermediate course
Tabs within a tab
Please first state which Training Course this forum post is about:
We attended an Excel training session and have a question... I am trying to sort out our spreadsheets for 2018. We have 4 tabs within the spreadsheet, however I would like 12 months within each tab... Rather than putting these all in the spreadsheet whcih would be very long, can you have tabs within tabs? I did Google this but bit confused with answer.
RE: Tabs within a tab
Please first state which Training Course this forum post is about: Excel Intermediate
RE: Tabs within a tab
Hi Emma
Unfortunately, it's not possible to create tabs within tabs on Excel.
However, if you store your 12 months of data in a list format on each tab, this would allow you to convert the data into a table and means you can easily sort and filter to make things quicker and easier.
To convert data into table format: click into the data, select the Home ribbon, Styles, Format as Table.
If you would like to summarise the data across the tabs then you could try using the 3D formulas or consolidation methods you learnt on your course.
Hopefully this answers your question, but let me know if you have any further problems.
Regards,
Sarah
Excel Trainer
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
