View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How can i keep "columb A" still at all times

The first point to look for help is in Excel help.

You know that if you click on row 2 and freeze panes it will freeze row 1.
Well, similarly if you click on column B and freeze panes it will freeze
column A.
If you click on cell C3 and freeze panes, it will freeze rows 1 & 2 and
columns A and B, in other words it will freeze everything above and to the
left of the selected cell.
--
David Biddulph

"K M Snowdon" <K M wrote in message
...
I have created some hyperlinks in columb A, and i would like them to remain
in veiw when i scrolll DOWN the sheet, Normal freezing only works when i
scroll ACROSS the sheet, and not downwards. Imagine just like a web page
really. HELP WOULD BE MUCH APPRECIATED, THANKS KEV.