Removing Scroll Bars


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.


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.