Skip to content

How To Blog

how to

  • 3 Discord Games For Gaming & Anime Fans Gaming
  • How to Install Custom Fonts on iOS 13 How-To
  • Export SQL Data to Excel with Column Headers How-To
  • How to Add a Program to Startup in Windows XP Windows XP Tips
  • What is a Firewall and What’s Its Purpose? Networking
  • How to Block YouTube Channels
  • Change Your Mindset and Your Output with These Five Productivity Apps Software Reviews
  • What Are Hot Corners On a macOS & How To Set It Up OS X

How to Open Multiple Instances of Excel

Posted on October 6, 2020 By blog_786 No Comments on How to Open Multiple Instances of Excel

If you’ve ever worked with multiple workbooks in Excel, you know that it can sometimes cause problems if all workbooks are open in the same instance of Excel. For example, if you recalculate all formulas, this will be done for all open books in one copy.

If you don’t want this, or just want to see both of your tables side by side in two different windows, then creating multiple instances of Excel makes sense. You can still split the screen into multiple tables in a single instance of Excel, but I find it cumbersome and not intuitive.

Excel versions

Before we dive into the details, you must determine which version of Excel you are using. If you have Office 2016 or Office 2013 installed, you have nothing to worry about because whenever you open a new workbook, it automatically creates a new instance of Excel.

Only Office 2010 and earlier versions have a problem with one instance of Excel. In this article, I will introduce different ways to make Excel open different workbooks in different instances.

Multiple instances of Excel

Typically Excel spreadsheets are opened by double-clicking on them in Explorer or by navigating to them from Excel. Using either of these two methods will open the spreadsheets in one instance of Excel.

Method 1. Start Menu

First method – Start menu

The first way to work around this is to simply open the Start menu and then click the Excel shortcut. This will automatically open a new instance of Excel. Please note that this will work on Windows 7, Windows 8 and Windows 10.

How to Open Multiple Instances of Excel

If the Excel icon does not appear in the list of most used applications, you can simply go to All Programs in all applications and open it from there.

Method 2 – Taskbar

The second method – the taskbar

If you already have one instance of Excel open and the Excel icon is on the Windows taskbar, you can simply press and hold the SHIFT key and then click the icon in the taskbar and another instance will open.

How to Open Multiple Instances of Excel

Note that the Excel icon is not actually pinned to the taskbar. All you have to do is open one instance of Excel so that it appears in the taskbar. Once there, you can hold SHIFT and click the icon.

Method 3 – Middle Button

The third method – the middle button

If you are using a mouse with a middle button or a clickable scroll button, you can also simply click that button to get a new instance without holding down any key. If you didn’t already know, the scroll button can also be clicked like a button on almost any mouse.

How to Open Multiple Instances of Excel

It’s also worth noting that you can also just right-click the Excel icon in the taskbar and then click Excel 20xx and a new instance will open.

How to Open Multiple Instances of Excel

Method 4 – Run Command

Fourth method – run command

If Excel is not on the desktop, on the Start menu, or on the taskbar, you can still open a new instance of Excel by using the Run command. Just click “Start”, type “Run” and press “Enter”.

How to Open Multiple Instances of Excel

Now just enter the word excel in the run box and click OK.

How to Open Multiple Instances of Excel

These are almost all the ways I could find to open multiple instances of Excel. Now that your workbooks are open in different instances of Excel, you can link them to different parts of the screen.

Luckily, I’ve already written about how you can split the screen in Windows XP, 7 and 8, and the new split screen and snapping features in Windows 10.

Again, you don’t need to worry about this if you’re using Office 2013 or Office 2016, because they no longer open multiple workbooks in the same instance of Excel. It can also be a good reason to upgrade to a newer version of Office if you’ve been holding back for a long time. If you have any questions, do not hesitate to comment. Enjoy!

–

MS Office Tips

Post navigation

Previous Post: 5 Free Online OCR Services Tested and Reviewed
Next Post: How to Access Yahoo! Mail using POP3 or IMAP

Related Posts

  • How to Create Form Letters in Word MS Office Tips
  • How to Hide Sheets, Cells, Columns, and Formulas in Excel MS Office Tips
  • Use Excel as a Tool to Copy Data from the Web MS Office Tips
  • Add a Linear Regression Trendline to an Excel Scatter Plot MS Office Tips
  • How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel MS Office Tips
  • Export Contacts from Outlook, Outlook Express and Windows Live Mail MS Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • January 2023
  • December 2022
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018

2021 Android ) Apple apps Best browser change Chrome Closing words Concluding remarks Download email Error Facebook From Google Image Internet Keyboard Mac make Movies Music online Packaging phone? Photos Print Shortcuts sites Switch Time Tips Tricks turn using Video Videos Watch What With Word Working? your YouTube

  • Don’t See 4K at 60 FPS Record Video Option on iPhone 8 Plus/X?

    Don’t See 4K at 60 FPS Record Video Option on iPhone 8 Plus/X?. <p>Have you just bought your shiny new iPhone 8, iPhone 8 Plus, or iPhone X? I also! Well, the first thing I did was change my settings so that I could record videos in amazing 4

  • 5 Photo Recovery Tools Tested and Reviewed Computer Tips
  • How To Fix Magic Keyboard Caps Lock That Doesn’t Work Hardware
  • How to Fix ‘RPC Server is Unavailable’ Error in Windows Help Desk
  • How to Share Files Through Nearby Share on Android How-To
  • 15 Best Places To Sell Your Photos Online Cool Websites
  • Best ti84 ce graphing calculator 2020

    Best ti84 ce graphing calculator 2020

  • Software Apps To Effortlessly Convert Music Files To Different Formats

    Software Apps To Effortlessly Convert Music Files To Different Formats

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
View preferences
{title} {title} {title}
Go to mobile version