Wednesday, 16 March 2016

EXCEL : Keep Column Names Visible as You Scroll

Many Worksheets have Headers for each column. As you scroll thru a worksheet it’s helpful to be able to see those names. Here’s how. 
  • Select the row immediately below the row you want to freeze.
  • In the Window menu, click on Freeze Panes. Excel will put a thick line under the row to freeze. 
  • To unfreeze the row, go to Window menu again and click on Unfreeze Panes

No comments:

Post a Comment