Prantick Bala
Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to remove panes in different situations. The earlier article might help you to add panes, following the continuity, in this article, I’ll show you how to remove panes in Excel in 4 different ways.
Suppose, you have the following dataset with panes. Now, go through the rest of the article to know the ways of removing panes in Excel.
Download Practice Workbook
4 Ways to Remove Panes in Excel
1. Remove Panes With Double Click
The easiest way to remove panes is to double click on the panes.
➤ Keep your cursor on one of the panes and double click on it.
As a result, this pane will be removed.
In a similar way click on the other pane to remove it.
2. Remove Panes Using Split from View Tab
You can also remove panes from the view tab.
➤ Go to the View tab and select the Split icon from the Window tab.
As a result, the panes will be removed from your Excel datasheet.
Similar Readings
- How to Remove Grid from Excel (6 Easy Methods)
- Remove Borders in Excel (4 Quick Ways)
- How to Remove Partial Data from Multiple Cells in Excel (6 Ways)
- Remove Checkbox in Excel (6 Methods)
- How to Remove Number Error in Excel (3 Ways)
3. Keyboard Shortcut Key to Remove Panes
In this section, I’m going to share with you a way that you may find easy to use if you like the keyboard rather than the mouse. Let’s how to use a keyboard shortcut key to remove panes.
➤ To remove panes, press,
ALT+W+S
It will remove all the panes from your Excel worksheet.
4. Unfreeze Panes
If you activate the panes from the Freeze Panes option, you can remove them with the Unfreeze Panes option.
➤ Go to View > Freeze Panes and select Unfreeze Panes.
It will remove all the panes from your Excel worksheet.
Practice Section
I have added a dedicated worksheet named “Practice” in the Excel file. You can download the workbook from the Download Practice Workbook section and practice removing panes from the “Practice” worksheet.
Conclusion
I hope now you know how to remove panes in Excel. If you have any confusion feel free to leave a comment.
Related Articles
- Data clean-up techniques in Excel: Replacing or removing text in cells
- Data clean-up techniques in Excel: Fixing trailing minus signs
- How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)
- Remove Password from Excel (3 Simple Ways)
- How to Remove Data Validation in Excel (5 Ways)
- How to Remove Strikethrough in Excel (3 Ways)
