Excel new tab creation issue in microsoft office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1637331%22%20slang%3D%22en-US%22%3EExcel%20new%20tab%20creation%20issue%20in%20microsoft%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637331%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
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?
1 Reply

@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