I'd Like to Switch From "Print View" to "Normal View"


New Member
Dec 19, 2017
[FONT=&quot]Hi all,[/FONT]
[FONT=&quot]Forgive me if I'm violating any forum rules: I'm new to this site and posting on forums in general. I've read the rules of this, I've searched through many SOLVED threads, and I still have a question. I really hope you guys can help.[/FONT]
[FONT=&quot]I'm working on a couple of sheets in Excel 2016, and for one reason or another one of the sheets has entered what I call "Print View" while the other remains in what I call "Normal View".[/FONT]
[FONT=&quot]Normal View (SHEET 2) https://imgur.com/RiSBmOj[/FONT]
[FONT=&quot]Print View (SHEET 1) https://imgur.com/TSC37Sd[/FONT]
[FONT=&quot]Normal View I characterize as a sheet view that only contains cells, while Print View I characterize as a sheet view that contains cells that might fit on a printed page: It shows an image of an 8.5"x11" page with areas for headers, footers, and margins. I would like to have both sheets in Normal View, and for my own edification I'd like to know how to enter and exit these views.[/FONT]
[FONT=&quot]I'm looking forward to hearing from you. Thank you.[/FONT]


Oct 23, 2004
From the Ribbon, goto tab VIEW, then at the left you have Normal / Page Break Preview / Page Layout

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...