View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Keep Top Row and Side Column always visible

Place the cursor in cell B2 and do Windows Freeze Panes

Vaya con Dios,
Chuck, CABGx3



"Anti-Spam" wrote:

I have a simple spreadsheet which has many rows, most of which are
outside the visible area on my screen. The top row (number 1) has my
column headings, trouble is as soon as you scroll down the headers
disappear off the top of the screen. Is there any way to lock them, so
they do not scroll with the rest of the sheet. Thanking you in
anticipation.

Mark in Spain.

XP Pro
Excel version 2002
XP Office Pro