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

Cybersecurity threats proliferating for midsize and smaller businesses

This report details how SMBs can properly protect private information from breaches, design and implement a cybersecurity policy, and create safeguards for training and education.

QUIZ

Test yourself on these often confused words

The spelling checker on your word processing program can do only so much to flag problems. Your best insurance is to learn the troublesome words that trip up writers and use them correctly by the standards of formal, written English.