Allign sheet tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-1639723%22%20slang%3D%22en-US%22%3EAllign%20sheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639723%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20created%20sheet1%2C%20sheet3%2Csheet2%2Csheet4%2C%20sheet5%20and%20so%20on.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20to%20i%20allign%20the%20sheets%20to%20sheet%201%2C2%2C3%2C4%2C5%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1639723%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1639740%22%20slang%3D%22en-US%22%3ERe%3A%20Allign%20sheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780831%22%20target%3D%22_blank%22%3E%40Raj_123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20that%20you%20want%20to%20sort%20the%20tabs%20in%20alphabetic%20order%20of%20their%20name%3F%20See%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2018%2F05%2F02%2Falphabetize-tabs-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20alphabetize%20tabs%20in%20Excel%3C%2FA%3E%20(works%20for%20names%20ending%20in%201%20...%209)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1639742%22%20slang%3D%22en-US%22%3ERe%3A%20Allign%20sheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639742%22%20slang%3D%22en-US%22%3ENot%20by%20name....i%20have%20created%20the%20sheet%20tabs%20in%20between%20and%20i%20want%20all%20those%20alligned%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1639768%22%20slang%3D%22en-US%22%3ERe%3A%20Allign%20sheet%20tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1639768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F780831%22%20target%3D%22_blank%22%3E%40Raj_123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20afraid%20I%20don't%20understand%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
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?
7 Replies

@Raj_123 

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)

Not by name....i have created the sheet tabs in between and i want all those alligned

@Raj_123 

I'm afraid I don't understand

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?
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