New sheet tab creation issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1637475%22%20slang%3D%22en-US%22%3ENew%20sheet%20tab%20creation%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637475%22%20slang%3D%22en-US%22%3EThere%20are%2015%20tabs%20in%20the%20excel%20sheet(%20it%20is%20an%20already%20saved%20excel%20sheet%20on%20the%20desktop%20as%20ABC.xlsx).%20Out%20the%2015%20sheet%20tabs%2C%20i%20have%20deleted%20sheet4%2Csheet6%2Csheet11and%20sheet%2013.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20my%20sheet%20selection%20is%20on%20sheet2.when%20i%20click%20on%20new%20sheet%20option(%2B)%20the%20new%20sheets%20created%20are%20sheet4%2Csheet6%2C%20sheet11%20and%20sheet13%2C%20i%20want%20the%20new%20sheets%20to%20start%20from%20sheet16%20instead%20it%20is%20creating%20all%20the%20old%20deleted%20sheets%20first..why%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1637475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1638453%22%20slang%3D%22en-US%22%3ERe%3A%20New%20sheet%20tab%20creation%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638453%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%3BYou%20have%20posted%20on%20the%20Microsoft%20Learn%20community%20which%20is%20all%20about%20exams%2C%20certification%20and%20training.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20would%20have%20better%20luck%20on%20the%20Excel%20community%20board%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor
There are 15 tabs in the excel sheet( it is an already saved excel sheet on the desktop as ABC.xlsx). Out the 15 sheet tabs, i have deleted sheet4,sheet6,sheet11and sheet 13.

Now my sheet selection is on sheet2.when i click on new sheet option(+) the new sheets created are sheet4,sheet6, sheet11 and sheet13, i want the new sheets to start from sheet16 instead it is creating all the old deleted sheets first..why?
2 Replies

@Raj_123 You have posted on the Microsoft Learn community which is all about exams, certification and training.

 

You would have better luck on the Excel community board https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral

Hello @Raj_123 

 

That is build into Excel since the first days. Excel keeps track of the numbers of the sheets but does not continue where you want but where it thinks it would be fitting like a gap in your numbering.

I personally always rename my sheets to my needs and ignore the numbering.

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42