These frozen rows and columns will remain visible as you scroll through the worksheet. They may be times when you need to keep multiple rows or multiple columns "frozen" at the top of to the left of your screen.Įxcel will use dark lines to indicate when any rows or columns have been frozen. The most common use for this is when you are scrolling a large table of information and you want to keep the column and row headings visible while you scroll through the whole table. It can be useful to freeze parts of a worksheet to allow you to freely move to other parts of the worksheet. You can unfreeze the window at any time by selecting (Window > Unfreeze Panes. The row and column headings will remain on the screen as you scroll around the worksheet. You can freeze both the upper and left panes by clicking the cell below and to the right of where you want the split to appear. You can freeze the left vertical pane by clicking the column to the right of where you want the split to appear. You can freeze the top horizontal pane by clicking the row below where you want the split to appear. This can be prevented by taking advantage of the Freeze Panes. Many large worksheets contain row and column headings to identify the data in tables.Īs you scroll the worksheet the headings will often disappear from view. The frames that are not frozen will scroll but will not affect the area that is frozen. Using freeze panes lets you keep the column headings or row titles visible while while you scroll to other parts of the worksheet Magically, the top rows and left columsn of our sheet are frozen in place when we scroll.Freeze panes allow you to freeze the top or left or both on the active worksheet. Then, we'll head to the View tab and select the Freeze panes option from the Freeze panes menu: Let's scroll back up to the top of our sheet and position our cursor directly below and to the right of the rows and columns that are important to keep when we scroll: To fix this problem, Excel has a handy feature called Freeze Panes. We've got data on the screen, but we're not sure which column headings correspond to which columns: Check out the following screenshot, for example, in which we've scrolled around a large data set. When we're working with large sheets of data, it's easy to forget what pieces of data certain rows and columns represent. Choosing the 100% zoom option will reset zoom settings to the Excel default. Hitting this button will open up a zoom options box that allows us to select a specific level of zoom for our sheet. If we want to set a specific zoom level, we can also click the current zoom level (by default, 100%), which is shown next to the zoom bar on the bottom-right hand side of the screen. We'll drag this slider to the right to zoom in: Fortunately, Excel makes zooming easy: we can do it using the slider on the bottom-right of the screen: Our Excel sheets can contain quite a bit of data, and often it's helpful to be able to zoom in and out to either magnify data, or fit more data on the screen. In this tutorial, we'll take a look at both of these features to get a feel for how they can help us navigate our sheets. Freezing panes in ExcelĮxcel offers a few extremely helpful user interface features that make viewing our sheet easy: zooming and freezing panes. By submitting this information, you agree to Deskbright's privacy policy and terms of service.
0 kommentar(er)
