View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how do i prevent a row from moving, like subheader that is visibl

If you want row 1 to stay fixed, select row 2 & use Windows/ Freeze Panes.

If you want to freeze both rows and columns, if you select cell C3, for
example, before selecting Windows/ Freeze Panes, then it will freeze rows 1
and 2 and columns A and B. In other words it will freeze rows above and
columns to the left of the selected cell.
--
David Biddulph

"Binmaru" wrote in message
...
In Excel, how do I prevent a row from moving, like a subheader that I want
to
stay always visible at the top of my document?