When working with a large amount of data, it is convenient to have the header rows always displayed, irrespective of how far into the worksheet you have scrolled. This avoids the need to scroll back to the top of a worksheet to find out which header a particular data entry comes under. To do this, select the header row by clicking on the appropriate section head number, or simply select the cells that you want to freeze. Then go to View > Freeze Panes. You can do this for rows as well as columns, and at the same time. Select the row or the column, and go to View > Unfreeze Panes to remove the freezing. Doing this without selecting any row or column will unfreeze all the Panes in the worksheet.



Reply With Quote
Copyright Techfuels
Bookmarks