Repeating Column Headers And Blank Worksheets With Fomulas

K

Konax

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
 
F

Frank Kabel

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
 
Top