TUG News & Updates: General

TUG Tip -- Sage 300 CRE

Wednesday, February 6, 2019   (2 Comments)
Posted by: Sheree Ross, Philadelphia D&M, Inc.
Share |

TUG Tip - Sage 300 CRE

Excel - New Window View

Ever use an Excel file (workbook) with multiple worksheets and need to see how a change in one worksheet will affect a formula in a different worksheet within the same file?  You can use the New Window feature in the View Menu to open a second window for your document.  This allows you to "work in different places at the same time."  If you have two monitors it is really nice.  You can have a different worksheet on each monitor to easily see how a change on one affects the other!

 


Have a comment or question?  Post it below.

Have a tip to share?  Submit a tip here

Comments...

Sheree Ross, Philadelphia D&M, Inc. says...
Posted Monday, April 8, 2019
Hi Shawna. When you have an Excel file open the filename appears at the top in the center. As soon as you select "View, New Window" a copy of the workbook is created and the filename appears with " - 2" after it. A "-1" will appear after the original file opened. You can then drag one of them to your 2nd monitor. You can switch between worksheets as needed on each monitor. Hope that helps.
Shawna Cramer, Breiholz Construction Co says...
Posted Tuesday, March 19, 2019
How can you get them on each monitor? I have tried multiple times an still can't get it to work

About Us Membership Knowledge Exchange Events Resources
About Join Now Advocate to Sage Community Calendar Get Connected ⇓
Leadership ⇓ What Members Say User Communities Regional Workshop Affiliate Members
TUG Board of Directors Member Orientation Committees National Conference Associate Members
TUG Past Presidents Get Involved Advertise with TUG
TUGweb Tutorials
TUG Staff Follow Us on Social Media

FAQs
Contact Us Get Rewarded

Career Center

3525 Piedmont Rd Building 5, Suite 300 Atlanta, GA 30305 Phone: (866) 846-0999

Email: info@TUGweb.com

Connect with TUG