How do I repeat a group of rows at the bottom of each page in Exce
I have a selection of rows that I need to repeat at the bottom of each page
such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. |
How do I repeat a group of rows at the bottom of each page in Exce
It's never been built into excel in any version I've used (xl95 through xl2007).
Stomp74 wrote: I have a selection of rows that I need to repeat at the bottom of each page such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. -- Dave Peterson |
How do I repeat a group of rows at the bottom of each page in
really, so there is no way to reproduce this as you do at the top of the page
then? "Dave Peterson" wrote: It's never been built into excel in any version I've used (xl95 through xl2007). Stomp74 wrote: I have a selection of rows that I need to repeat at the bottom of each page such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. -- Dave Peterson |
How do I repeat a group of rows at the bottom of each page in Exce
As Dave said, Excel has no built-in way to repeat rows at the bottom of a page. It can be done with VBA code, but the code is complicated. You may want to try the free trial of my commercial Excel add-in "Special Print". It includes a "Rows to Repeat at Bottom" utility. No registration required. However, I have no reports back on its usability in XL2007. (it should work) So, if you do try it I would appreciate hearing your comments. Download from the Products page at... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone Portland, Oregon USA (Excel Add-ins / Excel Programming) "Stomp74" wrote in message I have a selection of rows that I need to repeat at the bottom of each page such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. |
How do I repeat a group of rows at the bottom of each page in
Thanks Jim,
Gave your program a go but it was not compatible with the 2007 version, error message comes up and the chosen rows are duplicated as seperate entities and not attached at all to the original chosen rows. Anyway thanks for the help. Steve "Jim Cone" wrote: As Dave said, Excel has no built-in way to repeat rows at the bottom of a page. It can be done with VBA code, but the code is complicated. You may want to try the free trial of my commercial Excel add-in "Special Print". It includes a "Rows to Repeat at Bottom" utility. No registration required. However, I have no reports back on its usability in XL2007. (it should work) So, if you do try it I would appreciate hearing your comments. Download from the Products page at... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone Portland, Oregon USA (Excel Add-ins / Excel Programming) "Stomp74" wrote in message I have a selection of rows that I need to repeat at the bottom of each page such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. |
How do I repeat a group of rows at the bottom of each page in
Steve, Appreciate you letting me know. Do you happen to remember what the gist of the error message was? Jim Cone "Stomp74" wrote in message Thanks Jim, Gave your program a go but it was not compatible with the 2007 version, error message comes up and the chosen rows are duplicated as seperate entities and not attached at all to the original chosen rows. Anyway thanks for the help. Steve "Jim Cone" wrote: As Dave said, Excel has no built-in way to repeat rows at the bottom of a page. It can be done with VBA code, but the code is complicated. You may want to try the free trial of my commercial Excel add-in "Special Print". It includes a "Rows to Repeat at Bottom" utility. No registration required. However, I have no reports back on its usability in XL2007. (it should work) So, if you do try it I would appreciate hearing your comments. Download from the Products page at... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone Portland, Oregon USA (Excel Add-ins / Excel Programming) "Stomp74" wrote in message I have a selection of rows that I need to repeat at the bottom of each page such as you can in page set up with the top of the page with "Rows to repeat at top of page", now I am sure this used to be acheivable with past editions of Excel but I cannot find this function with the current version. I am using MIcrosoft Office Excel 2007. |
All times are GMT +1. The time now is 11:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com