Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to auto insert rows in Excel
Hello
I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
#2
|
|||
|
|||
Tanya
Have you taken a look at DataSubtotals? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "TanyaG" wrote in message ... Hello I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
#3
|
|||
|
|||
Data--Subtotals
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "TanyaG" wrote in message ... Hello I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
can't insert more rows even though not at max rows | Excel Worksheet Functions | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
Auto Insert of Rows | Excel Worksheet Functions | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Discussion (Misc queries) |