How Do I View One Sheet Only In Excel 2016

Anonymous
2017-07-04T06:48:25+00:00

Hi,

I just want to view one single page view in Excel 2016, that's all.

We do this with Word:

With Excel, all you get is this:

Why is this so difficult?

-Jason

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    2017-07-04T11:59:16+00:00

    I think this is not possible (at least for now). Excel worksheets are not technically pages but rows and columns. Page view only separates them based on the page breaks.

    Hmm, this view can be useful though (sort of like a print preview perhaps?). I can only suggest to post this in the feedback forum.  -> Excel’s Suggestion Box

    0 comments No comments
  2. Anonymous
    2017-08-15T17:59:25+00:00

    I agree that this would be very helpful. I seem to recall this use to be an option some way - without hiding the rows and columns that you didn't want to see. I'm not positive that it did use to be an option, but I know that it's possible in Excel for Mac computers. I came across this article: http://www.brighthub.com/computing/mac-platform/articles/116629.aspx 

    It seems odd that it would be available in Mac but not Windows.

    0 comments No comments