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