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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

Learn to choose between ‘who’ and ‘whom’

Writers can stumble over who and whom (or whoever and whomever). If you write for business, this quiz can help make your copy above reproach.