View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zoom zoom zoom zoom is offline
external usenet poster
 
Posts: 3
Default **freezing rows **

I have a workbook with 14 worksheets in it and they all have the rows frozen
to display the columns. When I save several of these workbooks to a
workspace, close, and then re-open the workbooks, all of the rows are
unfrozen. Two questions: How do I keep all rows frozen in all worksheets?
and, How do I freeze all worksheets within each workbook without going page
by page? (All worksheets are identically set-up and represent months of the
year for data input).

Thanks to whoever can help with this possible bug.