ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I repeat rows at foot of worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/72982-how-do-i-repeat-rows-foot-worksheet.html)

Debbie Iles

how do I repeat rows at foot of worksheet?
 
I am trying to create a spreadsheet whereby I want to repeat rows at both the
top and bottom of each page. The top I have sorted, although I need to
automatically put a gridline across the bottom of the page. Can anyone help
please

Bernard Liengme

how do I repeat rows at foot of worksheet?
 
There is no way to repeat a row (or rows) at the foot of a page. You can
only use View | Headers & Footers to add a footer. Some one more versed in
VBA may prove me wrong with rows at bottom.

Non Brits: Debbie means she as 'sort out' not 'put in some order' when she
says she has 'the top sorted'

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Debbie Iles" <Debbie wrote in message
...
I am trying to create a spreadsheet whereby I want to repeat rows at both
the
top and bottom of each page. The top I have sorted, although I need to
automatically put a gridline across the bottom of the page. Can anyone
help
please





All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com