I have this excel here: http://www.mediafire.com/?l35mvmhtcv1vu88
the rows 18-33 are sort of the detail area, i want to add 19 rows to this area but also keep the summary level rows within this same sheet.
I copy the row 18 to 26 and right click on 27 and "insert copied cells" it askes paste shift right or down. if i select down it inserts the rows as I want but if i continue to add more rows my totals area gets pushed off the page which is 47 rows total
so can i increase the page size? and will this method work ok.
Thank you very kindly,
Phil
the rows 18-33 are sort of the detail area, i want to add 19 rows to this area but also keep the summary level rows within this same sheet.
I copy the row 18 to 26 and right click on 27 and "insert copied cells" it askes paste shift right or down. if i select down it inserts the rows as I want but if i continue to add more rows my totals area gets pushed off the page which is 47 rows total
so can i increase the page size? and will this method work ok.
Thank you very kindly,
Phil