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

A new line of business to consider

Technology assessments may open the door to new engagement opportunities for your firm. What is a technology assessment? How do you perform one? JofA Tech Q&A author J. Carlton Collins shows you in a detailed explanation.

FEATURE

Maximizing the higher education tax credits

A counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.