Get More Room in the Spreadsheet Window

BY STANLEY ZAROWIN

Q. Is there a way to get rid of the sheet tabs on the bottom of my Excel window? I’m looking for ways to provide more vertical space on my worksheet.

A. Yes, you can eliminate the sheet tabs from the screen. If your goal is to provide more vertical space, however, there is something else you can do in addition. But first, here’s how to remove the sheet tabs from view—recognize, however, that the underlying sheet tabs are still there; they’re just hidden. Click on Tools, Options and go to the View tag. Under Window options , uncheck the Sheet tabs box and click on OK and the tabs will be hidden.


To bring them back, go through the same process and check the Sheet tabs box.

The other thing you can do to increase the work space is to convert to a full screen view, a step that will hide the toolbars. To do that click on View and then Full Screen , and the top of the screen will look like this:


To reverse the process click on Full Screen again and the toolbars will return to this:

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

COLUMN

Deflecting clients’ requests for defense and indemnity

Client requests for defense and indemnity by the CPA firm are on the rise. Requests for such clauses are unnecessary and unfair, and, in some cases, are unenforceable.