Repeating Column Headers And Blank Worksheets With Fomulas
 

I have two questions about excel: In my spreadsheet I have titles for all my
columns that I have typed in the first cell of every column and I was wonder
how you make those titles repeat on every page of the spreadsheet. My second
question is how do you take an exsiting spreadsheet and then make a new
spreadsheet thats blank but have all the formulas as the original one.

Thanks

Hi
1. Question:
- for printing: file - Pagesetup - sheets' and define your repeating rows
-for display: Move the cursor below your heading row and goto 'Windows -
Freeze Panes'

2. Question:
After copying everything, select your data area, hit F5, choose 'Special',
choose 'Constants' and then hit the DEL key

--
Regards
Frank Kabel
Frankfurt, Germany
"Konax" schrieb im Newsbeitrag
...

I have two questions about excel: In my spreadsheet I have titles for all
my
columns that I have typed in the first cell of every column and I was
wonder
how you make those titles repeat on every page of the spreadsheet. My
second
question is how do you take an exsiting spreadsheet and then make a new
spreadsheet thats blank but have all the formulas as the original one.

Thanks