This step-by-step illustrated guide outlines how to freeze panes in Excel, how to freeze columns in Excel, how to freeze title lines and how to freeze multiple lines.
Find more technology guides, tips and advice
Contents
How to freeze panes in Excel
How to freeze the top row in Excel
How to freeze multiple rows in Excel
How to freeze columns in Excel
How to freeze a column and row together in Excel
Perhaps this has happened to you before: You are working with a long table in Microsoft Excel … you are somewhere very far down and suddenly you no longer know in which column the value you are about to enter actually belongs. Was the field for the date of birth now in column three or in column four? The only thing that helps is scrolling up, checking and scrolling down again.
A pleasant alternative to this is to freeze the first row of the table. This is how it is displayed regardless of how far down the document has been scrolled. Freezing multiple rows or columns is also easily possible in Excel.
This function is used to freeze rows or columns in a worksheet. For jobs that use ms. Excel’s row or column freezing is designed to keep the worksheet visible when the user scrolls vertically or horizontally.
This feature is commonly used for freezing headings or column headings, and are also used in tables with many parameters, so the heading will appear even when the user is scrolling. We will show you how it works. However, there are two things to consider before using these freezer tools.
1. Window Freeze Function can be done to freeze the top row, the first column which is far right, or a row and column at the same time.
2. However, this function cannot be used while editing cell.
How to freeze panes in Excel
There are different types of freeze functions for panes, rows and columns in the Microsoft Excel program.
1. Freeze the top row
This type of freeze window is useful for keeping the top row visible while scrolling. To use it, you need to follow these steps.
a. Just click on any cell on the worksheet that you want to freeze.
b. On the tab menu, click Freeze Top Row View> Freeze Window> Freeze Window Top Row. Then you will get the following results.
You can see in the picture above that the top row is still visible when scrolling down and cannot be seen in row 2 through row 7. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.
How to freeze multiple rows in Excel
Fixing several rows at the same time in an Excel table works just as easily as freezing the title line. First mark the line that is directly below the lines that are to be fixed, because Excel always freezes upwards.
2. How to freeze columns in Excel: Freeze first column
The next type is freeze first column i.e. if it is useful to keep the first column visible even when scrolling. To use this type of feature, do the following.
a. As with the previous type, click any cell to freeze. See image.
b. Then click Freeze First Column in View Menu> Freeze Window> Freeze First Column. Then as in the previous type, you will get the following results:
In the image above, it can be seen that the first column, column A, is visible. If you scroll to the right, columns B, C and D cannot be seen.
3. Freeze a column and row together
Next up is the freezer steps for a column and a row at the same time. The purpose of this feature is to keep certain rows and columns so that they are still visible when scrolling, based on the scrolling position. See the example below for more details. In this example, the top row and the first column are frozen at the same time. The steps are as follows.
a. You click below and also to the right of the row and column to freeze. And to freezing the top row and first column at the same time, you can click cell B2, not the other cell. Take a look at the picture below.
b. Next, click the Freeze Windows in the Show Menu tab > Freeze Window> Freeze Window . Then you will see the results as follows.
In the picture above you can see that row 1 and column A are still visible when scrolling down and to the right at the same time.
If you clearly understand how that was submitted in the review of this article, of course it will be easy to do. You can display the results correctly so that you can do your work with the Microsoft program. Excel is fluid and not blocked because you now have a good command of it.
Hopefully with the article that has steps on how to explore various features in the ms program. Excel provides a lot of insight for those of you who want to have a good mastery of this program so that you can use all the work you need this program to do as efficiently as possible, so that the work can be completed quickly.
CONCLUSION
Freezing rows and columns in Excel is a convenient way not to lose track, even in large tables. You are there with just a few clicks of the mouse; Annoying scrolling is a thing of the past.
