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

What is Pivot Table Example?

Image
So, how does using a pivot table to perform large scale enterprise business calculations look like? Check out the below example, in which we have used the Excel tool named Pivot Table to complete the task mentioned in the earlier blog i.e. Summing sales in dollars by customer. We were able to prepare the report in a matter of few seconds based on the input data tab. Take Note of a couple of things: it has captured the data we wanted (the sum of the Total Price column, segmented by customer); it has included a comprehensive list of customers on our input sheet; and it is ready for flexible adjustments and modification (see the Pivot Table Field List dialogue on the right-hand side of the screen). We have solved our analyst's problem. Potential uses of Pivot Tables At higher levels, Pivot Tables are more effectively used to summarize the data. Beyond that, they are infinitely flexible, and applicable to a huge variety of situations. Here are some of the more example scenarios...
Read more

What are the various Formatting options available in Excel?

Image
We can have a look at the various formatting options available in Excel by selecting a cell that contains a number and from thereon heading towards the Number formatting drop-down on the Home ribbon tab: Following are the most used formatting options that are available in Excel: Number. Excel would format your input as a generic number with commas in-between the thousands digits. Currency. Excel would format your input with a currency sign in front of it and two trailing digits after the decimal point. Accounting. Similar as the Currency format, but currency sign will align to the left-hand side of the cell. Date. Excel would format the given input as a date. Note that dates in the Excel are displayed as numerical quantities. Time. Excel would format the given input as a date or time. Times are also displayed as numerical quantities in the Excel. Percentage. Excel would format the given input as a Percentage. Like, an input of 0.76 will be read as 76%. It is important to not...
Read more

Making the Pivot Table in Excel

Image
Making the Pivot Table Now that our data is set in the right format, we can move on to creating the pivot table itself. For this tutorial, we have expanded on the sample data set above, adding in some more granular detail on the items ordered, quantity, price, and date: To create a Pivot Table based off of this data, we will first place our cursor anywhere within the data set itself. Then, we will go to the Insert section on the Ribbon and select the Pivot Table option: The Create Pivot Table dialogue box will open asking us to specify some of the options. Since Excel has already selected our data and the rest of the options work by default (e.g., we want our Pivot Table report to be placed in a new sheet), so we can now go ahead and just press OK on this screen. Our Pivot Table is ready to go! Notice that Excel has created a new sheet; there is now a Pivot Table graphic on the left-hand side of the screen; and a PivotTable Field List dialogue that has appeared on the righ...
Read more