Locking a row

  • Thread starter Thread starter Net Rover
  • Start date Start date
N

Net Rover

As an absolute newbie, can someone tell me how I can "lock" a row (of
column titles) so it stays on screen when I scroll down a sheet?

Thanks
 
Hi Net Rover!

If titles are in Row 1

Select A2
Windows > Freeze Panes

Selecting (eg) B2 allows freezing of Row and Column Headings

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Net Rover!

If titles are in Row 1

Select A2
Windows > Freeze Panes

Selecting (eg) B2 allows freezing of Row and Column Headings
Click to expand...
Great.

Thanks for the speedy reply.
 
Hi Mike!

Thanks for thanks!

Speedy? 19 minutes is a bit slow but Frank Kabel appears to have taken
the day off without permission.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top