How do I have excel automatically repeat the borders of all rows to a new
page. I know how to set up to have it repeat my first row with the titles of
each column and I am assuming that when I go into page setup/sheet that I can
choose "Rows to repeat at top" to include the whole page, but I'm not sure
how.

I've created a monthly log and I don't want to create new pages with
copy/paste... if my data exceeds one page, then I would like my page
formatting to automatically display on the new second page and so on...

Ok, let me start by saying that 'pages' aren't really involved until you
print a worksheet, or view it in Print Preview.

The "Rows to Repeat at Top" is referring to what rows to print at the start
of each new physical sheet of paper when you print a worksheet. So if you
are only using 1 row for the titles of the column, the entry in it in Sheet
setup would look like:
$1:$1
If you had 3 rows of information that you wanted printed at the top of each
physical printed page, then the entry would look like $1:$3

But you won't see rows $1:$1 or $1:$3 repeated on the worksheet itself.
You'll only see them repeated in Print Preview or when actually printed; and
then only when the amount of information on the worksheet extends down far
enough to require more than one sheet of paper to print it all on.

Now, as for formatting additional entries on your worksheet, there are
several ways to do that. First, Excel is pretty good about formatting new
entries on a sheet based on the format of the cell above it. So the
automatic side of things may help you some as you add new entries. But
borders are not part of that feature. And the bad side of borders is that if
you set them up all down the sheet for a couple of hundred (or thousand) rows
in anticipation of maybe entering data later, when you go to print the sheet,
Excel thinks you want all those empty bordered cells printed also! You can
eat up a lot of paper that way.

A quick way to format new rows of information added to the sheet that don't
have borders and such already set is to use the [Format Painter] tool. It is
on the Standard toolbar (the one with the icons for new workbook, open file,
save file and such). It looks like a paintbrush. To use it, first click the
row number on the left edge of a worksheet that has information and cells all
formatted the way you want, then click the [Format Painter] tool. Then click
on the row number for a row you want formatted that same way. The row will
take on all of the formats from the one you chose to start with. If you
click on an unformatted row (number) and hold down the left mouse button and
drag on down the sheet over several row numbers, then all of the rows you
dragged over will take on the formatting of the initial row you chose.
Search Excel Help for "Format Painter" for more information on this feature.

Hope this helps some.

"MrReeLady" wrote:

How do I have excel automatically repeat the borders of all rows to a new
page. I know how to set up to have it repeat my first row with the titles of
each column and I am assuming that when I go into page setup/sheet that I can
choose "Rows to repeat at top" to include the whole page, but I'm not sure
how.

I've created a monthly log and I don't want to create new pages with
copy/paste... if my data exceeds one page, then I would like my page
formatting to automatically display on the new second page and so on...

Hi
I am not sure exactly what you are asking here, since it appears that you have answered your own question. But to repeat more than 1 row, say rows 1-6, you would type in the row to repeat: $1:$6. This will repeat rows 1-6 on every page and would include the borders and shading of rows 1-6 etc.

garry