Stack Spreadsheets On The Screen

BY STANLEY ZAROWIN

 »  Key to Instructions  
To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of files and the names of commands and instructions that users should type into the computer.

 

STACK SPREADSHEETS ON THE SCREEN
We had a brief power outage and now I can’t keep multiple Excel files open on my screen. Each time I open a second file, the first one disappears from the screen, and when I close that second file, the first one instantly reappears. Can you help?

I don’t know whether the power outage was the cause of the problem, but that experience with the brief blackout should prompt you to install an uninterruptible power supply (UPS), which is a powerful battery linked to your computer. In the event of an outage, the battery is programmed to kick in immediately, automatically saving and closing open files and then safely turning off your computer. It can be set up for a network as well.

As for your Excel problem, it’s likely that somehow a default setting changed. It could have been caused by the power outage or a misplaced click in the Options menu. In any case it’s easy to fix. Click on Tools , Options and then the View tab and add a check in the box next to Windows in Taskbar (see screenshot).

Not only can you now display several files on your screen, but their identifying icons will appear in your desktop’s toolbar as well (see screenshot).

By the way, Word has a similar default. If you suddenly find you can’t display more than one Word file, click on Tools , Options and then the View bar and likewise place a check at Windows in Taskbar .

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