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 to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.