How to Remove Panes in Excel Worksheet (Shortcut)

Excel has a feature where it allows you to divide a worksheet into two or four panes.

This helps as you can treat each of these panes separately and can scroll and move within each pane.

This was introduced as a productivity feature as it allows you to work with large datasets with ease.

But what if you want to remove the panes from the worksheet (so you see everything as one single worksheet)?

Table of Contents

Remove the Panes with Double-Click (Shortcut)

Another quick way to remove the panes is to simply double click on the line that separates the two panes (a thick gray line).

As soon as you double-click on the line separating the two panes, the line would go away.

In case you have your worksheet divided into four panes you need to double-click once on the horizontal line and once on the vertical line.

If you’re not a huge fan of using the mouse and would rather prefer a keyboard shortcut to get rid of the panes use the below one:

ALT + W + S

Also read: How to Remove Page Breaks in Excel?

Below are the steps to remove the panes from an Excel worksheet:

The above steps would remove all the panes and give you back a single wholesome worksheet.

So these are two simple ways to remove the panes from a worksheet in Excel.

I hope you found this Excel tutorial useful!

Other Excel tutorials you may like: