Protected worksheet

[Guest]

I want to have my speadsheet be viewed ONLY as normal, and NOT as a page
break. How do I set that protection, that a student will not be able to even
choose page break? I am using the spreadsheet online in a testing format.

 

[Harlan Grove]

I want to have my speadsheet be viewed ONLY as normal, and NOT as a
page break. How do I set that protection, that a student will not be
able to even choose page break? I am using the spreadsheet online
in a testing format.

Excel provides no means of preventing users from viewing any visible
worksheet in page break preview mode. If you controlled the machines
that would be displaying the workbook, you could disable the menu item
View > Page Break Preview. If not, there's no way to prevent users
from selecting this mode (because you can't modify their View menu),
and selecting this mode triggers no event that you could monitor.

Simply put, you can't do this in Excel.