Add Multi Subtotal Rows at Once | Excel Short Tips & Tricks

Insert subtotals rows in a list of data in a worksheet

You may learn how to enter multiple subtotals or additional rows at once on this page by following these simple instructions.  

1. Select the column.

 

2. Go to Find & Select.

3. Select Go To Special

4. Select Constants and press OK

5. Excel automatically selects groups

6. Now go to Insert and select the Insert sheet Row.

 

Insert New Row Between Every Row

Tags : #excel  tutorial #excel #tricks #exceltips #rows #insert #learn #online #youtuveshorts #data  #entry #work #computer #spreadsheet #shorts #educational #office #microsoft #microsoftexcel #msexcel #msexcelfullcourse #exceltips #exceltutorial #beginners #how_to #microsoft_excel_tutorial #shortcuts #exceltricks #corporate #excellence #workhacks  #business #excelskills #onlinelearning #excelprofessional #advancedexcel #advancedexceltraining #spreadsheet #msexceltips #free #databasemanagement #support #reels #finance #accounting #accounting_freelancing #exceltips #tipsandtricks #tips #dataanalytics #technology #online #studentlife #excel_2019 #data_entry_jobs #parttimejobsforstudents #parttimejob #tool #tools #step_by_step_tutorial #amazing #course

Subscribe to us: @YOGITARANI31