Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Multiple Spreadsheets within a workbook
Resolved · Low Priority · Version Standard
Despina has attended:
Excel Intermediate course
Excel Advanced course
How can you display the spreadsheets within a workbook in alphabetical order to make it easier to find especially when working with several spreadsheets.
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
|
Excel tip:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |
We'll call during UK business hours
Server loaded in 0.11 secs.