View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Excel locked cells


"Dave Semple" wrote in message
...
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. :-)