Excel locked cells

D

Dave Semple

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
 
D

Doug Kanter

Dave Semple said:
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 to expand...

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. :)
 
Top