How to Remove Panes in Excel (4 Methods)

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.

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.

Read More: How to Remove Value in Excel

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.

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.

Read More: How to Remove Outliers in Excel

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.