Here's How to Use Freeze Panes in Excel, Data Entry becomes Easier!

Here's How to Use Freeze Panes in Excel, Data Entry becomes Easier!

Geekers - Do you know what Freeze Panes are? Freeze panes is a feature that is owned by Microsoft Excel, where this feature functions to freeze rows or columns in one worksheet. The goal is that the row or column you want does not shift or remains visible even though the worksheet is scrolled, either vertically or horizontally.


Usually, these freeze panes are used when entering large amounts of data. This will make it easier for you to see a field in which there are many parameters that you may not necessarily remember all of them. So, you can still continue with the next data entry activity without having to scroll many times because you don't remember the header of the column or row.



The question is how to use freeze panes in Excel? Well, in this article you can get the answer. Come on, see the following explanation.


How to Use Freeze Panes in Excel


In general, these freeze panes are widely used to display the column headers or titles of a table. Thus, you can read data from the table. In Excel itself, there are three freeze heat options that you can use, namely:


A. Freeze Panes


This feature you can use to freeze whichever area you want. So, you can still view rows or columns simultaneously without having to re-scroll. For more details, see the following steps.



1. First, please open the Excel file that was created earlier. Pay attention to the sheet before freezing as shown below.


How to Use Freeze Panes in Excel How to Use Freeze Panes in Excel


2. Determine which cells you freeze. Here I will freeze the row and column simultaneously, so that cell C2 is highlighted.


i will freeze row and column simultaneously i will freeze row and column simultaneously


3. Then, click the VIEW tab on the ribbon menu. Select Freeze Panes > Freeze Panes.


Select Freeze Panes > Freeze Panes Select Freeze Panes > Freeze Panes


4. Then the result is that when you scroll vertically, the first line will still be visible. Likewise, when scrolling horizontally, columns A and B will still be visible.


columns A and B will remain visible columns A and B will remain visible


B. Freeze Top Row


Freeze Top Row is used to freeze the first row. So when you scroll vertically, the first line will still be visible. Here are the steps to use it.


1. Determine the cells that you will freeze. Here, I'll select rows A1:E1 to freeze. Then, highlight the cell that is after the cell that will be frozen. Meaning I will highlight rows A2:E2.


selects rows A1:E1 to freeze selects rows A1:E1 to freeze


2. To freeze the top row, select the VIEW tab on the ribbon menu. In the Window section, there are Freeze Panes, then select Freeze Top Row.


How to Use Freeze Panes in Excel How to Use Freeze Panes in Excel


3. This is the final result after the cell is frozen. So rows A1:E1 will still be visible even if you scroll vertically.


How to Use Freeze Panes in Excel How to Use Freeze Panes in Excel


C. Freeze First Column


Finally, Freeze First Column is used to freeze the first column. The steps are as follows.


1. Highlight the same cell as before, namely cell C2.


2. Freeze First Column can be done by clicking on the VIEW tab. Then tap Freeze Panes and click on Freeze First Column.


How to Use Freeze Panes in Excel How to Use Freeze Panes in Excel


3. And the end result, column A will still be visible if you scroll horizontally.


How to Use Freeze Panes in Excel How to Use Freeze Panes in Excel


That's an article about how to use freeze panes in Excel. That way, your work when doing data entry is not hampered. You can also turn off the freeze by selecting “Unfreeze Panes”. Hopefully the above article can help you and good luck.



RELATED TUTORIALS

   * How to Permanently Activate Microsoft Office 2019

   * 2 Ways to Sort Data in Microsoft Excel

   * 2 Ways to Make Upper and Lower Ranks in Microsoft Excel

   * How to Make Graphs in Microsoft Excel for Beginners

Share:

Top Ads

Responsive Ads

Bottom Ads

Responsive Ads