Removing Scroll Bars

BY STANLEY ZAROWIN

Q. Is there a way to remove the scroll bars on the sides and bottom of Excel so I can have a larger screen view of my spreadsheet?

A. There is, but be aware that when you remove them you can no longer control the view of the spreadsheet with your mouse. You will be limited to using the cursor control keys—the four keys with arrows pointing up, down, left and right.

Here’s how you remove the scroll bars: While you’re in Excel, click on Options from the Tools menu and the View tab, which will display the screen below.

Under Window options , on the bottom, in the far right column are two boxes— Horizontal scroll bar and Vertical scroll bar . Remove the checkmark from either one or both. Of course, you can always replace them later.

Another option for increasing the viewing space is to go to View in the toolbar. Click on Full screen and the toolbars and format bar will disappear, giving you lots more viewing space while retaining the scroll bars—that is, if you haven’t already eliminated them.

By the way, you can do the same thing in Word.

You can eliminate the side and bottom scroll bars in Excel for more viewing space.

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out