Moving Between Open Workbooks in Microsoft Excel

 

In this article, you will learn how we can move between open workbooks by using the shortcut keys in Microsoft Excel. You will learn 3 options to move one file to another file:-

  • From one Excel file to another Excel file
  • From Excel file to Word file
  • From Excel file to Internet Explorer

Let’s take an example to understand how we can move between open workbooks.

We have opened two excel worksheet, opened internet explorer and word document. Now, we want to move between 2 excel worksheets, Excel to the word document and Excel to Internet Explorer.

To move between 1st Excel file to 2nd Excel file

Follow below given steps:-

  • Open both of the Excel file.
  • Press the key  Ctrl+Tab on your keyboard.
  • By this way, we can move first Excel file to second Excel file.

img1
 
To move from Excel file to Word document

Follow below given steps:-

  • Open both files, Excel & Word document
  • Press the key ALT+Tab on your keyboard
  • By this way, we can move from Excel file to Word file

img2
 
To move from Excel file to Internet Explorer
Follow below given steps:-

  • Open both of the Excel files
  • Press the key ALT+Tab on your keyboard
  • By this way, we can move Excel file to internet explorer

img3
 
This is all about how we can move between open workbooks in Microsoft Excel.

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com



4 thoughts on “Moving Between Open Workbooks in Microsoft Excel

  1. its not working! all i want is to be able to move from sheet 1 to sheet 2 to sheet 3 and so on. anything i’m doing wrong? tip says to do ctrl+tab or ctrl+f6.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>