To freeze columns and/or rows so they stay on screen when you scroll, click in a cell that is beneath the rows you want to freeze and/or to the right of the columns you want to freeze.
Excel 2003 users
Click Window | Freeze Panes
Excel 2007/2010 users
Click View [tab] |Freeze Panes |Freeze Panes
NB. Go back to the same commands to unfreeze panes.
No comments:
Post a Comment