#1   Report Post  
Posted to microsoft.public.excel.misc
Dave Semple
 
Posts: n/a
Default Excel locked cells

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
locked cells TED MEDIN Excel Discussion (Misc queries) 6 January 5th 06 11:40 PM
How to partially lock the cells in Excel? Locking cels in Excel Excel Discussion (Misc queries) 1 September 19th 05 02:21 PM
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Filling cells (autofil?) in Excel 2003 Hnelg Excel Discussion (Misc queries) 3 July 5th 05 02:47 PM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 06:31 AM


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"