Panning Worksheets

  • Thread starter Thread starter Lester Boegemann
  • Start date Start date
L

Lester Boegemann

Have worksheet that is wide and long. Wish to pan across
and down worksheet, while retaining the top row (titles)
and left column (case numbers) on the monitor.

I have done this before, but gee, I just forgot how to do
it again.
 
Lester, select B2 then window freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Lester,

Select cell "B2"
From the menu bar ...
Windows/Freeze Panes

This will keep the first row and column visible while you pan.
(change B2 to what you need)

John
 
Back
Top