excel training program - multiple spreadsheets within wor

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

resolvedResolved · Low Priority · Version 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


 

Excel tip:

Changing the Tab Colour of an Excel 2010 Worksheet

Did you know you could give the tabs in your worksheet different colours?

This is particularly useful when organizing all your worksheets relating to a particular period or year, for example.

Right click a tab
Select Tab Colour
And choose your favourite colour!

View all Excel hints and tips


Server loaded in 0.11 secs.