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 QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.