ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the sheet or tab order in an existing workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/218032-how-do-i-change-sheet-tab-order-existing-workbook.html)

Hannah

How do I change the sheet or tab order in an existing workbook?
 
I have what seems to be a simple problem, but I can't do it. I have an
existing workbook with data in it and I have decided I want to change the
order of the sheets (tabs). Can I do this

Mike H

How do I change the sheet or tab order in an existing workbook?
 
Hannah,

Hold down the ALT key and point the mouse at the sheet tab and hold down the
left mouse button and drag the sheet to it's new location.

Mike

"Hannah" wrote:

I have what seems to be a simple problem, but I can't do it. I have an
existing workbook with data in it and I have decided I want to change the
order of the sheets (tabs). Can I do this


David Biddulph[_2_]

How do I change the sheet or tab order in an existing workbook?
 
Click on the tab of the worksheet you want to move. Hold down the mouse
button and drag the tab to its new position in the list.
--
David Biddulph

"Hannah" wrote in message
...
I have what seems to be a simple problem, but I can't do it. I have an
existing workbook with data in it and I have decided I want to change the
order of the sheets (tabs). Can I do this





All times are GMT +1. The time now is 12:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com