Formatting Headers

  • Thread starter Thread starter kurting0
  • Start date Start date
K

kurting0

This is a simple problem but I cannot remember how to remedy it. I am
working in a large worksheet and want to keep the column headers on the
top of the page as I work my way down the page. Thanks.
 
If col headers are in row1, row headers down col A

try:

Click on B2
Click Window > Freeze Panes

Col A will stay in view as you scroll across to the right
Row1 will stay in view as you scroll down

Adjust the "corner cell" B2 of the frozen panes accordingly to suit

To "re-freeze" panes at another corner cell,
unfreeze panes first via click Window > Unfreeze Panes
then select the new corner cell and click Window > Freeze Panes
 
Back
Top