Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel training program - multiple spreadsheets within wor

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Multiple Spreadsheets within a workbook

excel training program - Multiple Spreadsheets within a workbook

ResolvedVersion Standard

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.