is it possible to freeze multiple panes in excel

#Is it possible to freeze multiple panes in excel how to#

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.

#Is it possible to freeze multiple panes in excel how to#

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 Hi, i have data in columns A:F going down to around 10000 rows. Is it possible to do this with Freeze Panes Only Columns A-F. 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. Is it possible to do this with Freeze Panes Only Columns A-F. At first tap to the View tab and now from the Window group, choose the Freeze Panes arrow sign. 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.Select the cell below the rows and to the right of the columns that we want to freeze when. In the Window group, select Freeze Top Row We can freeze the panes in three different ways.Freeze to1.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! As of I know, there is no way to freeze multiple panes. Save hours and eyesore by using freeze panes in Excel