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

[happydz]

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!

 

[Artik]

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

Artik

 

[happydz]

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.

 

[Artik]

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

 

[happydz]

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)

 

[Artik]

Unfortunately not, because that is not the purpose of this view.

Artik