![]() Read More: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts) This is how we can easily freeze the header in Excel Sheet by using a keyboard shortcut. Immediately after selecting Freeze Panes, we can see there appears a darker horizontal line underneath row 4. Immediately after clicking W, then we have to click the F button to select Freeze Panes.Īfter, we have to select the F button again to select our desired Freeze Panes. Then, we have to click on the W button to select the View option. Let’s click on the ALT button from the keyboard and Ribbon appears before something like this. Therefore, to perform this method, we have to select row 5 first.Īfter selecting row 5, now it is time to apply the keyboard shortcut. As we have discussed before, we want to freeze row 4 as our header in this Excel sheet. We can easily perform this task in a cool way by using a keyboard shortcut ALTR + W + F + F (one after another). Freeze Header in Excel Using Keyboard Shortcut “ALTR + W + F + F” Related Content: How to Freeze Frame in Excel (6 Quick Tricks)Ģ. ![]() Immediately after selecting Freeze Panes, there appears a darker horizontal line underneath row 4. Open the View tab > go to Freeze Panes > select Freeze Panes.Now, we have to follow the following steps. To freeze row 4 as a header, we have to select row 5 first. ![]() Here row 4 is our desired row whom we want to freeze in this Excel Sheet. This is one of the basic methods to freeze the header in an Excel Sheet. Now we are going to discuss the top 4 methods to freeze the header in Excel Sheet.
0 Comments
Leave a Reply. |