Freeze 1/2 a document so the other can be formatted differently?

C

Charlie

To lock the top 1/2 of the worksheet place the cursor in a
cell under the row you want locked, then in the file menu
select Windows/Freeze Panes or Windows/Split

Charlie O'Neill
-----Original Message-----
I have 1/2 a sheet of cells formatted into blocks -- for
Click to expand...
fields -- now how do I make columns under this info?? Can
I lock the above information somehow to format the bottom
of the document into columns?? I know I can I just don't
know where or how>>>
 
C

Charlie O'Neill

If you select say A12 and then Windows/Freeze Panes you should be able to
scroll the bottom pane with the top pane frozen and vise versa. Are you
saying the scroll doesn't work?

Charlie O'Neill
 
Top