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

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.