Show only active page

[lorenambrose]

I am running office 365 and have Excel 2016 on my machine.

I have a spreadsheet that is in "Page View" but I only have info on the 1st page. However I still see grayed out pages beside and below.

Is there a way to only show the one page without the grayed out ones?

Regards,
L. Ambrose

 

[sijpie]

Yes. Select all unused columns (select one, then Ctrl - End - Rightarrow). Right click and select Hide.
Do the same for unused rows

 

[NoSparks]

My 2010 doesn't have 'Page View', it has a 'Page Layout' which sounds like what you describe.
On the View ribbon > Workbook Views section > select 'Normal'