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

DSullivan

New Member
Joined
Dec 19, 2017
Messages
2
[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]
[FONT=&quot]-DSullivan[/FONT]
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
From the Ribbon, goto tab VIEW, then at the left you have Normal / Page Break Preview / Page Layout
 
Upvote 0

Forum statistics

Threads
1,214,864
Messages
6,121,986
Members
449,058
Latest member
oculus

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