Using Excel on both monitors and you're in two separate files, but you want each file to recognize each other.
Example:
You have a number on one file in left monitor and another number in another file on your right number. How do you multiply (or do anything really) the number in file X (left monitor) by number in File Y (right monitor)? Is this not possible?
| +228 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 55 | 8h |
| +134 | ONLY THESE BANKS OR YOU STRUCK OUT | 36 | 3m |
| +111 | IB Energy Drink Tier List / Ranking | 73 | 21h |
| +91 | PJT M&A Group Selection 2026 | 14 | 2d |
| +59 | Firm Thinks I'm Lying About Offer | 18 | 1d |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 2d |
| +44 | Indiana University Fraternity Pipelines | 29 | 1m |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 2h |
| +32 | Rogo AI | 12 | 2h |
| +31 | Elite Boutique interview questions | 8 | 5h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
To get another excel open on my 2nd monitor, I have to open Excel again and then open whatever file Im looking for, so Im assuming thats why the two files dont acknowledge each other since they are two different instances of excel.. but im wondering if there is a way
wait really? ... just link the cells.
type in your formula and reference the other worksheet... (alt+tab to jump to the other worksheet)? maybe i'm not getting your question...
edit: ohhhh. nvm i see what you're saying. sorry, can't help. excel 2013 lets you open multiple instances now though, if your bank's upgraded.
You can still do it the same way you would do it if it were to be on the same instance of excel instead of two instances except when you update the numbers it doesn't auto recalculate. You have to save the file that you changed the number on, and then recalculate numbers on the other one. Annoying. yes. But possible.
Also, when I copied just the file name over like it would be done when done in the same instance of Excel, it automatically put in the whole path of the file instead. ex. Instead of "[filename.xlsx]Sheet 1"$A$1 it's C://Desktop/filename.xlsx....
A non pretty fix is to resize the excel window across both monitors and manually resize each book to fill one monitor.
That would actually be the simplest way and would look pretty much the same. other than the tool bar at the top.
This
Labore maxime fuga est quia et ut ipsa. Odit fugiat voluptas architecto eum incidunt ea. Vel dolor rerum qui cumque est. Dolor optio quisquam autem ipsa rerum atque.
Dicta eos explicabo est delectus dolore nesciunt dolorem doloribus. Est est repellendus similique. Illo atque ut in et quis. Consequatur omnis quam rerum qui dolores vitae.
Sint ab vero dolor eius. Et velit nostrum explicabo fuga nisi. Pariatur reiciendis quis voluptatem ipsa consequatur. Ipsa hic ipsam neque ut nostrum qui distinctio molestias. Placeat laudantium fuga ut quaerat sequi non. Et velit inventore omnis. Et qui exercitationem odit.
Aut ut at ut asperiores. Nam et velit numquam veniam. Explicabo dolor rerum facilis culpa id eius ut. Et sed praesentium repudiandae ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...