Get More Room in the Spreadsheet Window


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:


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.