How do I keep two Excel Files open at one time--once I click on another excel

N

Norman Harker

Hi Betty!

Unless you close one, the first remains open.

Try Windows > Arrange

Also

Tools > Options > View
Check "Windows in taskbar"
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
E

Earl Kiosterud

Betty,

In addition to Norman's comments, you can switch between the two (or more)
open workbooks with Window (Menu bar). Or use Ctrl-Tab for a keyboard
shortcut. Or if you've used the Windows in Taskbar option Norman mentioned,
you can click on the workbook you want in the taskbar.

The bottom line is that when you open a workbook (or start a new one), it
adds another open workbook. They remain open until you close them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Re-title multiple MS Project .mpp files at once 0
Insert multiple objects at once ? 3
How to open multiple instances of Word 365? 5
Excel file won't save to iCloud on Mac 0
Visio shape text disappears upon copy paste 1

Top