Difference between freezing and splitting panes This feature is also particularly useful when sharing Excel spreadsheets with others so as to enable easier navigation and hopefully comprehension of the data shared. In the Window group, select Unfreeze Panesīy using freeze panes the time you save over multiple uses really can mean hours saved in the long run.In the Window group, select Freeze First Column.In the Window group, select Freeze Top Row.In the Window group, select Freeze Panes. Select the first cell of data (for the area you wish to scroll through, not frozen!).Ĭlicking this button will display a menu of freeze options that you can choose from. To use Freeze Panes, open a workbook window, and click the Freeze Panes button on the View tab. If you’re not already familiar with how to freeze panes in Excel, read on and save yourself some time. Reviewing data in spreadsheets can be very demanding on the eyes and time consuming when you are trying to remember what a particular column or row of data actually is! Save hours and eyesore by using freeze panes in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |