Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Multiple Spreadsheets within a workbook
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training program - Multiple Spreadsheets within a workbook
Resolved · Low Priority · Version Standard
Reply Thu 13 Dec 2007, 17:20Delegate Despina said...
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.
For upcoming training course dates see: Pricing & availability
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
|