![]() Freezing Panes in Old Versions of Excelįollow these directions for freezing panes in Excel version 2003 and older. In older versions of Excel, open the worksheet, on the top menu line click Window, and click Unfreeze Panes. Just open the worksheet and in the Windows section of the ribbon's View tab, click Freeze Panes ▼ and click Unfreeze Panes as shown below. ![]() It's easy to unfreeze panes in an Excel worksheet. We've scrolled in both directions, but can still understand the data! Note: all rows above, and columns to the left, of the selected cell are frozen regardless of whether they contain headings or other data. ![]() Notice the heavier lines around the locked rows and columns. The image above shows our worksheet with the frozen panes, which we've highlighted in yellow.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |