View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default How to keep 1st column visable when scrolling

Try this:

Select the 1st cell under and to the right of the rows/columns you want to
always display.

From the Excel main menu:
<window<freeze panes

Note: to unfreeze the panes <window<unfreeze panes

Example:
Select cell C3
<window<freeze panes
Now columns A and B, and rows 1 and 2 will always be visible as you scroll.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"TomC" wrote:

I am trying to figure out how to keep the 1st column visable when scrolling
across the spreadsheet.
--
MCP