test_man2
New Member
- Joined
- Aug 28, 2007
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Greetings! Is there a way to open the same spreadsheet (on the same computer) twice so that one can view two different worksheets at the same time? I'd like to reference worksheet1 while building a formula in worksheet2 without having to flip back and forth. Right now, the only way I can think of doing that is to make a copy of the spreadsheet, perhaps name it name_ref1, and then open both spreadsheets. Is there a way to open just one spreadsheet instead?