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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.