hideItAllandRevert-r1.xlsm

<div>
Dave, this works great. &nbsp;Thanks a ton!
</div>


<div>
Glad it works for you!<br />
<br />
Anything else you need on this one?<br />
<br />
Dave
</div>


Glad it works for you!

Anything else you need on this one?

Dave

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
In Excel (2010), I'm trying to shave off everything around the perimeter so that the display shows nothing but spreadshet cells. &nbsp;So far, I have been able to hide the following:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Row and Column headings<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Formula bar<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Horizontal and Vertical scrollbars<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Status bar*<br />
<br />
However, &nbsp;I have not yet been able to determine how to hide the three remaining bars at the top:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Title bar<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Row of tab headings<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; • Quick Access Toolbar (QAT)<br />
<br />
Is it even possible to hide or remove any or all of those bars?<br />
<br />
Thanks<br />
<br />
*I was not able to find a command in Excel Options to hide the Status bar. &nbsp;However, some time ago an EE Expert gave me the following VBA code which does the trick:<br />
<br />

<pre><code id="code-10-27695698-1">Sub ToggleStatusBar()
Application.DisplayStatusBar = Not Application.DisplayStatusBar
End Sub</code></pre>
</div>
</div>


Hello,

In Excel (2010), I'm trying to shave off everything around the perimeter so that the display shows nothing but spreadshet cells.  So far, I have been able to hide the following:

          • Row and Column headings
          • Formula bar
          • Horizontal and Vertical scrollbars
          • Status bar*

However,  I have not yet been able to determine how to hide the three remaining bars at the top:

          • Title bar
          • Row of tab headings
          • Quick Access Toolbar (QAT)

Is it even possible to hide or remove any or all of those bars?

Thanks

*I was not able to find a command in Excel Options to hide the Status bar.  However, some time ago an EE Expert gave me the following VBA code which does the trick:

(CODE)

View nothing but cells in Excel spreadsheet

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.