Done a form in excel and i want the headers (in row a) to print on every page. it will be a really long spreadsheet that we keep adding to and i want to be able to see the cells in row a on every page when it's printed out.
2006-11-21 01:43:25 · 3 answers · asked by venom 2 in Computers & Internet ➔ Software
File...
Page Setup...
Select "Sheet" tab
Fill in the "Rows to repeat at top" section
2006-11-21 01:50:14 · answer #1 · answered by Anonymous · 0⤊ 0⤋
File
Page Setup
Sheet "tab"
press the little box on next to "rows to repeat at top"
select the row/s you wish to repeat
2006-11-21 02:01:50 · answer #2 · answered by robdunf 4 · 0⤊ 0⤋
What you want is to do a be conscious Merge. Create your style in be conscious and set the format there. Then click on procedures -> Letters and Mailings... -> Mail Merge you could then merge your Excel sheet into the be conscious rfile and print out one style in line with record/respondent. whilst you're utilising be conscious 2003, the wizard on the the main suitable option is amazingly astounding.
2016-12-17 13:43:28 · answer #3 · answered by ? 4 · 0⤊ 0⤋