how do I change the order of worksheets in a workbook

G

Guest

In Excel 2007, how do I change the order of worksheets in a workbook? In
Excel 2003 I could move the worksheet tabs at the bottom of the workbook
 
G

Guest

It should be the same as 2003. Either click and drag the worksheet tab to
the desired position, or right-click and select "Move or Copy".

Is the Workbook protected? If so, try unprotecting it (under the Review
Tab) and see if you can move them then.

HTH,
Elkar
 
G

Guest

Thanks ... it is protected BUT I entered the correct password to "unprotect"
it when I opened it. The Review |Protected tab has the following checked
- Protect Structure & Windows
- Unrestricted Access

I would have thought this is sufficient to change the worksheet order.

But I did as you suggested ... removed the protection. Then I could
re-order. Then I put protection back on.

Thanks.
 

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

Similar Threads

How do I change the order of worksheets in a workbook 1
Set the print order of worksheets when printing entire workbook 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2003 - How do I reverse the order of sheet tabs in one step? 1
Linking multiple worksheets in one workbook 2
link to a specific worksheet of a workbook with many worksheets 1
Linking worksheets in the same workbook by names not cells 1
can I change page layout in an entire existing Excel workbook? 2

Top