Excel locked cells

[Guest]

tring to print a spreadsheet but 8 rows of data in the middle of page always
appear at top of every page.
checked for frozen cells, locked cells......help

thx,

Dave Semple

 

[Doug Kanter]

tring to print a spreadsheet but 8 rows of data in the middle of page
always
appear at top of every page.
checked for frozen cells, locked cells......help

thx,

Dave Semple

Click File, Page Setup, then the Sheet tab. Look at "Rows to repeat at top",
and see if the offending cells are typed in the space provided. The purpose
of this feature is usually to print column headings on each page. But, it
could conceivably be used for evil.