Locate the ribbon! Find the Window group on the View Tab. It is one of the most wanted time-saving features in Excel.
#How to freeze panes in excel how to#
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics".
These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. With freeze panes, whenever you move around in the worksheet, the columns and rows will display normally but they are locked. Hence to enhance the visibility of the column, you need to apply the freeze panes. When we scroll right, you will find company name will no longer be visible or the column that you want will not be longer visible. If any table has a freeze panes, then you will notice whenever you scroll down the data, the header will automatically scroll off. If you want the header row shown at the top then you need to apply freeze panes. You can freeze columns and rows at the same time. To unfreeze column, you must choose to unfreeze panes from the menu. To unfreeze the first column, you need to choose to unfreeze panes from the menu.įreeze First Panes: The column is visible portion will now be locked and remain visible whenever you scroll. After doing this, the first column of the worksheet will get locked and remain visible whenever you scroll. If you want to unfreeze the top row, select unfreeze panes for the menu.įreeze First Column: To freeze the first visible column, you need to select the freeze first column options. You will find that the top row is locked but it is visible as you scroll down the data. The Excel offers you three different options to freeze columns and rows.įreeze Top Row: If you want to freeze the top row of your list then select freeze top row option from the menu. As we scroll down the data, we find that the headers will automatically scroll off the screen. If you have a big size list, then you can freeze the headers and columns to make it visible while scrolling the data.
0 kommentar(er)
