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

States look to unclaimed property for revenue

This free report outlines the escheat process, common types of AUP, how different states are handling it and how companies can plan for potential audits and liabilities.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.