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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.