Sorting worksheets in workbook

  • Thread starter Thread starter LSB
  • Start date Start date
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.
 
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
 
Back
Top