View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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