How to Freeze Panes in Excel?
Freezing panes in Excel Excel has an extremely interactive UI that makes viewing spreadsheet easy like zooming and freezing panes. In this blog, we will learn how to use these features and how they help us navigate through our sheets. Zooming in and out Excel sheets sometimes contain a lot of data and an ability to zoom in and out, comes in handy. For data magnification or so that more data comes fits on the screen. Excel has this feature inbuilt, we can do it with the use of slider on the bottom-right of the screen: You need to drag this slider to the right to zoom in: And you need to drag it to the left to zoom out: To set the zoom to specific level, you can also click the current zoom level (which is by default, 100%), which is visible on the zoom bar on the bottom-right hand side of the screen. Using this button, opens up a zoom options box, that allows Excel Users, to select a specific level of zoom for their sheet. If one chooses the 100% zoom option, it ...