photo_angel2004 Wrote:
> I got it to work thank you, my last question is now that I have my
> colums with my slanted lines and the text right thank god. LOL
>
> Is there a way to format this document for all pages to have that same
> header on the top.
>
> What I mean is each colum header is a product.
> now the list that will go in rows benieth them is long.... 12 pages
> long.
>
> They need the top headers with the slants to be on the top of each page
> so its easy to read without having to go back to the first page to see
> the products. ??
>
>
Well, That would have been something to know ahead of time.
If you right click on the sheet tab at the bottom.
Then select "Select all sheets"
This will select all the sheets and the tabs will kinda turn white.
Then what ever you do to the first sheet will also happen on the other
sheets.
Or you can hold down "ctr" and then select the sheets you want, if you
don't want all of them selected.
Click on a tab to UNSELECT when you are through, or every thing else
you do will go to those sheets also.
Or you could select the rows you have done, then copy and go to the
other sheets and paste.
Or if you just want the format with out the text you could select the
cells you have done, then Double Click the format painter. Then go to
the other sheets and click in the cell where you want the format
--
Desert Piranha
------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread:
http://www.excelforum.com/showthread...hreadid=569292