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 will reset zoom settings to the Excel default.

Freeze panes

While doing work on large sheets of data, it sometimes happens that one forgets what pieces of data, certain rows and columns represent. Have a look at the below screenshot, for an illustration, in which we've scrolled around a large data set. You have got data on the screen, but unsure about the fact that which column headings correspond to which columns:
To get a solution to this problem, Freeze Panes feature of Excel comes in very handy. Now go back up to the sheet top and position the cursor directly below and to the right of the rows and columns that are very important to be kept during scrolling:
Then, head to the View tab and choose the Freeze panes option from the Freeze panes menu:
Now whenever we scroll, magically, the top rows and left column of our sheet are frozen in place. Now we can read our chart easily:
In future, you want the panes shall not remain frozen, then select the Unfreeze Panes option from the same menu:
Website : www.bexpertadvexcel.com Phone No : 8802329198

Comments

Post a Comment

Popular posts from this blog

Working with rows, columns, and cells

Image
Working with rows, columns, and cells As the name suggests, here in this article we would be discussing one of the Basic Excel Topics that BeXpert Advanced Excel Home Tuition covers. In Excel, every worksheet is organised into a grid of rows, columns and cells. These Individual cells can also be grouped into ranges, which are just a series of cells that are strung together. All these work in coordination with each other, in order to form the basic layout of an Excel document. Cell Addresses Below is the diagram that shows rows, columns, cells, and ranges all in one place: As it is clearly visible, that Excel labels columns letterwise. It is also visible that column labels are highlighted along the top of the screen: A, B, C, etc. Rows are highlighted along the screenside and organised number wise : 1,2,3 etc. At each row and column intersection is a cell, which is just one of the boxes on the grid of a worksheet. Every cell has a unique address that is a result of the c...
Read more

How to Alphabetization by multiple columns in Excel?

Image
Now, it is time to get fancy. We have learned how to sort and alphabetize by a single column. But what if we wish to sort by multiple columns — for example, alphabetize our order list by customer name first, but within each "customer name" block sort from the highest-value order to the lowest-value order? We can do this by using Excel's full sort functionality feature. First, we will start by selecting the whole range of data we want to sort. You can do this by clicking and dragging with your mouse to select all the cells you wish to sort, but there is a shortcut: make sure a cell within your data table you have selected, then press Ctrl + A on a PC or ⌘ + A on a Mac. When you are making this selection, it is very important to check to ensure that your entire table is highlighted before proceeding. If there are blank rows, then they may cause the Ctrl + A shortcut to only highlight part of the table; this will mess up your sorting or only partially sort the data. Alway...
Read more

Creating a one-dimensional summary in Excel

Image
Creating a one-dimensional summary Now that we have created our Pivot Table, let's start by creating a basic summary of total sales by customer. Firstly, add the Customer field to the summary. You can do this job, by either clicking the checkbox next to the Customer field in the PivotTable Field List, or by dragging the Customer field into the Row Labels section. Once we have done this, notice a few things: first, the Customer field has appeared in the Row Labels section of our sidebar. Second, a list of customer names has appeared within our Pivot Table. A list of customer names is very nice to have, but not particularly useful for data analysis purposes. Let us make things more useful by dragging the Total Price field into the Values section of our Pivot Table: Now we are getting somewhere! Our table has summed up the values in the Total Price column, segmented by the customer type. Notice that Excel has also automatically generated a Grand Total row that shows the total...
Read more