If you wish to have multiple views showing different areas of a spreadsheet you can use the Split option (found under the View tab) to create 2 or 4 split areas (which are scrollable) of your spreadsheet/worksheet. We have looked at how to freeze panes which are really useful when you wish to keep the headings for rows or columns of data from disappearing while you are scrolling through a spreadsheet. 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. If you want to freeze just one row, one column or both, click the View tab, then Freeze Panes. If you want to Freeze other rows as well just. Click on View on the Ribbon and select Freeze Panes. Here is a quick way to freeze the labels in place for fast and easy viewing of your data. 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. To do this, use Excels Freeze Panes function. If you have large and long workbooks or Excel spreadsheets, being able to see the column or row labels is extremely important.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. |