Forum Discussion
Allign sheet tabs
Hi,
I have created sheet1, sheet3,sheet2,sheet4, sheet5 and so on.
How to i allign the sheets to sheet 1,2,3,4,5?
I have created sheet1, sheet3,sheet2,sheet4, sheet5 and so on.
How to i allign the sheets to sheet 1,2,3,4,5?
7 Replies
- I believe you mean how to move the sheet tabs to have Sheet1, Sheet2, Sheet3 etc.
All you need to do is click on each of the sheet and hold down the left click then move to position them Sheet1, Sheet2, Sheet3 etc.
Regards- There are 80 sheets in total....it is difficult to click and reallign manually...is there any way to do it easily?
Do you mean that you want to sort the tabs in alphabetic order of their name? See How to alphabetize tabs in Excel (works for names ending in 1 ... 9)
- Hello,
You can check the link below to guide
https://www.google.com/amp/s/officetricks.com/rearrange-excel-sheets-custom-alphabetic-sort-order-vba/amp/- I opened the above VBA code, i could see the name as 'settings'...i need a VBA code to rename with the name sheet numbers only....say the order of the sheets now are sheet1,sheet3,sheet2,sheet4,sheet5,sheet7,sheet6....i want those to be realligned to sheet1,2,3,4,5,6&7...please help
- Not by name....i have created the sheet tabs in between and i want all those alligned
I'm afraid I don't understand
