how do I repeat rows at foot of worksheet?

[Debbie Iles]

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]

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 Iles@discussions.microsoft.com> wrote in message
news:6F77F350-F149-4240-9073-A508302A7E9E@microsoft.com...
>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