Despina has attended:
Excel Intermediate course
Excel Advanced course
Multiple Spreadsheets within a workbook
How can you display the spreadsheets within a workbook in alphabetical order to make it easier to find especially when working with several spreadsheets.
RE: Multiple Spreadsheets within a workbook
Hi Despina, Thank you for your post, in answer to your question, I not sure of a way to automatically sort the worksheets within the workbook, but you can do this manually, Drag the sheet tab into the required position you will notice a little down arrow showing the new location, or use the right click option on the tab and choose a location for the worksheet, note you can create a copy at this point.
To help with identification you could also colour your tabs, right click on a tab and choose tab colour from the ladder options, from the pallett choose your required colour.
I hope that helps, regards Pete