How Can I Hide Other Pages in Excel's Page Layout Mode?

happydz

Board Regular
Joined
Jan 11, 2017
Messages
63
Office Version
  1. 2010
I'm looking for a way to streamline my workflow in Excel while using the Mise en page (Page Layout) mode. I prefer this view over the Normal or Page Break Preview modes, but I find it distracting to see other pages when I'm focused on just one. I've attached a screenshot to illustrate the issue I'm facing (Hide the page to the right and others at the bottom). Is there a method to hide all other pages and only display the current working page in this mode? Ideally, I'm looking for a solution that does not involve using VBA or scripts. Any tips or tricks would be greatly appreciated!
 

Attachments

  • hide other pages.JPG
    hide other pages.JPG
    128 KB · Views: 9

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
All you can do is hide the columns and rows except for those needed for the first page.

Artik
 
Upvote 0
All you can do is hide the columns and rows except for those needed for the first page.

Artik
It did not work this way as when I hide the columns, they will be replaced by other columns from the next page and so on.
 
Upvote 0
Hide the columns from L to the end of the sheet (XFD) and the rows on a similar basis, such as from 45 to 1048576.

Artik
 
Upvote 0
Solution
Hide the columns from L to the end of the sheet (XFD) and the rows on a similar basis, such as from 45 to 1048576.

Artik
Thank you so much, it works fine, however, is there a way to center my current page (it is by default on the left side)
 
Upvote 0

Forum statistics

Threads
1,226,695
Messages
6,192,481
Members
453,727
Latest member
tuong_ng89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top