Sorting worksheets in workbook

L

LSB

I would like to know whether is it possible to sort the
worksheets in my workbook? How can I go about doing it? If
after the sorting, would I be able to move certain
worksheet to the front part. For example I have got the
following sheets in the following order:
Sheet9
Sheet3
Sheet2
Buy
Sell

I would like to arrange my sheet as follow:
Buy
Sell
sheet2
Sheet3
Sheet9

In short, I would like to put the Buy & Sell Sheets in the
front and the rest will be in alphabetical order.

Thanks in advance.
 
B

Biff

Hi LSB,

Just right click on the sheet tab and select move or copy.
You'll see all the sheets listed in their current order.
You can even move a sheet to another workbook if you want.
Just follow the directions in the dialog box. It's pretty
much self-explanatory.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top