small boxes with 1,2 above worksheet display after header footer was clicked

Question

I accidentally pressed the "insert-&gt;header footer" button, now i have 2 small boxes at the top left of my worksheet view, above it., and a large blank area to the right of this. &nbsp;I can't seem to remove them.&nbsp; How can I restore the prior view with which only shows the currently selected box contents and location line of data.

jkpieterse · Answer

jdlof1976&nbsp;You're in page layout view, at the botton-right of the Excel window you'll find three small buttons to change the view. This is the default view:

&nbsp;

jdlof1976 · Answer

JKPieterse&nbsp;&nbsp;Thanks but that didn't help.&nbsp;&nbsp;Here is my attempt at visualizing: green is normal, wanted.&nbsp; red is not normal, unwanted.&nbsp;&nbsp; I think it has to do with the header or footer setup.&nbsp;&nbsp;&nbsp; The "normal cell grid view" should be just below the top line of cell, fx, and cell contents display.&nbsp;&nbsp; (I can't post a picture.)z106fx&nbsp; &lt;cell contents display&gt;12&lt;normal cell grid view&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

jkpieterse · Answer

Sounds as if you grouped some rows maybe?

Forum Discussion

small boxes with 1,2 above worksheet display after header footer was clicked

3 Replies

Resources

<normal cell grid view>