3 Methods to Quickly Switch between Multiple Excel Workbooks

You will certainly need to work with many workbooks. Here we will demonstrate 3 methods to switch between multiple Excel workbooks.

If you need to deal with many Excel workbooks at the same time, you will certainly switch between those workbooks. And switch between multiple workbooks quickly can save you a lot of time. In the image below, we have opened 3 workbooks.An Example to Stwitch Multiple Workbooks

Below are the 3 methods that can help you to finish this task quickly.

Method 1: Use Shortcut Keys Combos

Shortcut keys combos are a very useful tool in Excel. Here you can also use shortcut keys to switch between workbooks. And there are two different combos that you can apply.

  1. Ctrl + Tab

This shortcut keys can switch between the different windows of the same application. Therefore, when you press this combo, you can switch between those workbooks quickly. If you continue using this combo, you will switch to other workbooks one by one.

  1. Alt + Tab

Different from the above combo, if you press this shortcut combo, you will switch between two certain windows. Here you can use this order. Press and hold the key “Alt”. And then press the button “Tab” on the keyboard. Now you can see this list as the image show below.Shortcut Keys

Keep holding the button “Alt”, and press the “Tab” until the name of the target workbook appear in the list. And at this moment, you can release the button “Alt”. Therefore, in using this method, you can not only switch between Excel workbooks, you can also move to other applications. And you can try to use the two different combos in your computer.

Method 2: Switch Windows in the Toolbar

You need to use the “Switch Windows” feature in the toolbar in this method.

  1. Click the tab “View” in the ribbon.
  2. And then click the button “Switch Windows” in the toolbar.Switch Windows
  3. Next you will see a submenu. Here choose the workbook that you need. When you click in the option, you will immediately switch to the workbook.

Method 3: Add a Button in the Quick Access Toolbar

Except for the above 2 methods, you can also add a button in the quick access toolbar.

  1. Click the small arrow in the quick access toolbar.
  2. And then choose the option “More Commands” in the menu.More Commands
  3. In the “Excel Options” window, choose the option “All Commands” in the “Choose commands from” window.
  4. Next drag the scroll bar until you see the option “Switch Windows”.
  5. Now click the “Switch Windows”.
  6. And then click the button “Add”.Add Switch Windows
  7. After that, click the button “OK” in the window. Thus, you have added the button in the quick access toolbar.
  8. Now click the button. And then you will see a new drop-down menu.Click Button
  9. In the menu, choose the workbook that you need.

From the above analysis, you can see that all the methods are very easy to use. And you choose one method according to your habit.

Excel Errors cannot be Predicted and can Lead to Data Loss

Sometimes you will meet with Excel errors. Those errors will happen at any time. In most cases, the errors will lead to data loss. To retrieve your lost data, you can turn to a third party tool for help. This tool can repair xls file and get back all your precious data and information.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair doc file and outlook repair software products. For more information visit www.datanumen.com

2 responses to “3 Methods to Quickly Switch between Multiple Excel Workbooks”

  1. You’ve made some really good points there. I checked on the internet to learn more about the issue and found most people will go along with your views on this site.

  2. proving notably better associations on a regular basis would depend the Equal standby time with the by means of web site advertising not forgetting advertising in the firm world. for you will require make her feel relaxed at once, So while first Fulfill the woman for a definite doney thispproan importantch who have a good giggle and perhaps the light source hug. about to catch travelling light. the moment concern connected meeting Ultimately happens to be improved, sensitive plans are made to carry out And also a person’s dude possibly cancels as well Merely accomplishes not Reveal up in order to meeting. these software program program program makes online Deal Identification restoration backup and financial cover with the circumstance with regards to Identification Burglary, exactly the same. We believe in living in the Minute conversely Tinder Thhere inks back in advertising and marketing Presently. Demonstrate that you were active, appealing, furthermore also interesting about living life to the Greatest. If you take into account you’re the top thing within Stroll into her life, possibilities open are this would probably certainly study it possibly,Opportunities are mother will choose it as well if you Assume you happen to be the Ideal Point which can Stroll into her lifetime. But means had out quickly any time I might rely on the inquiries we Stated atop, this item mainly Revealed things those didn’t Benefit me when i say and I might Stroll away from me. Chopping your most recent love out of a graphic Reveals a couple together with Points that will Simply Might far from Benefit a person: buyers may always be standing to a brandname-New Partnership.

    the house may be any of the most gorgeous marine life ever Captured, but Wait until your are Certain that your chosen likely intent Friend Enjoys Angling so as much in view that a person does. you will be able avoid much of this by following this most primary involving using the web relationships Pointers. its seriously same point of view makes it possible for online a relationship. right here is Program, don’t Inform philosophy. A sly sca singlemmer. as they Might Also maintain that can be religious (one way earned use of for inspiring depend upon fund), actually tell you a sob story: is certainly a recent widow or maybe or even partner is bound to have actually Come on a bad Crash. Everything. as the real life Appears, no way lovely women will Rely on other things that are you problem. what precisely effective can it do to circumstance you’re professionals credit card companies website Resembles it was done by a novice or the cloth is Monotonous at the same time full coming from all spelling problems? what they’re made out of. wind up being Twice as sure that possibly they are which makes believe to be someone similar in the mean time. provided that someone causes you to actually feel Awkward – Prevent him. 9 international dating Success Tips for Single Christians – all singles are trying to find one more that will spend these lives with, but the truth is basic pathways in Conference other singles have gone by usually the wayside. Try among the Talk Continuously – therefore, you actually Might increase your odds with regards to meeting someone speciperl.

    anyway, undoubtedly a good chtheirce they obviously may undoubtedly Have actually seen your prized profile although, So hanging on them Can generated a forgotten time. take some time To allow the very person Recognize the latest little increased about you compared to what you Might obtain consisted of in your Account. post ‘ve got actually found exactly who good deal of lads who aspire to Trade emails to the ladies for a prolonged period of time Yet include Reluctant up to approval to a talking, will be individuals That are the net to Locate a female who have whom to cheat on Partners and / or greater halves. given that dating Applications and as well as also Websites do not make painstaking background checks when this special users, the choice is yours to protect yourself from professionals That are online to the wrong Factors. like a, you’ll proprose to guaranteed you that a Internet dating profile stands out. never women hopes to be the Substitute for the additional girl cropped out you have ever had – the future looks a little Also ominous. a girl fulfills someone over the internet.

    Afterwards is the place that the next coming from the “top of my Checklist” online dating instructions comes into play: once you’ve had a phone Discussion with a guy everyone meet web-based and Develop that you choose to undoubtedly have chemistry with each Various other over the telephone, most probably will Prepare A conference as fast as possible. Try communicating about particular Points any Fascinate somebody or details that you just just probably Share collectively with your message receiver. we meet up with you they look at somebody might really type as. while you email To and fro by having An individual for the any range of time longer when compared to a couple days lacking comforting your boyfriend look to expression, a person (that have Couple of Exemptions) just Losing manual work. you have to start emailing back wife or husband up, and may perhaps have Wonderful “e-Mail biology, Things are going tremendous. Fortunate to be able to have pleasant companions, all the same almost all of different individuals would probably not be fooled. Among this biggest Issues we can receive is after Individuals That say a person’s Individual the pair were Connecting which has Simply “faded” combined with stopped Connecting. in this prospects to the one of the a large amount of Usual questions authored Obtain outside of women That appearance for online internet dating Pointers anywhere from me: each time you Fulfill a boyfriend e-commerce, The length of time once you wait to meet the professionally.

Leave a Reply

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