There are two different options here, you can either press the F5 key or use the Ctrl + G keyboard shortcut to bring the Go To window up. But even if you already know the basics, there are always a few more tricks that can improve your overall experience working in the app. If you have installed Office Tab in your computer, it helps you view and edit multiple files within a single tabbed window, to know more about Office Tab Office Tab and download it (free trial in 30 days). What Excel automation tips do you know and use? Opening a second Excel file can complicate things a little bit. In order to switch between sheets in your Excel workbook, follow these steps: You can navigate around your Excel workbook and jump from one sheet to another using hyperlinks as well. Of course, there will always be new tips and tricks that you can learn about this software. When you’ve got to switch between them, the obvious choice would be to do it by manually selecting a different sheet at the bottom of the workbook. Amazing! In the pop-up window, choose the sheet you want to link to and type in the cell reference where you’d like the hyperlink to take you. Using the Go To command is another handy way of moving around your Excel worksheet. In order to switch between sheets in your Excel workbook, follow these steps: Open your Excel workbook. Read Anya's Full Bio. You will especially appreciate this method if you have to deal with overloaded Excel documents with lots of rows and columns on a daily basis. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. After installed Office Tab, and open multiple workbooks, you will see all the workbook names have been displayed within a single tabbed window as following screenshot shown, and then you can quickly switch among them by a click. This device is known as a switch, and its purpose in this circuit is to establish or interrupt the electrical continuity of the circuit in order to control the light bulb. That command will take you to a different sheet and move the active cell box to the cell you’ve chosen. However, with more than two opened workbooks, this method doesn’t work very well because it will cycle through each opened workbook. Home » Worksheets. From the options in the middle of the box, choose, Move on to the Anchor line below, find the. So you can find a list of all your previous cell references in the top box above the Reference line. Download and free trial Kutools for Excel Now ! Some methods — such as the Go To command — can be accessed using keyboard shortcut key combinations, which, at times, can be easier and quicker to use than the mouse.But follow our full guide to find the most comfortable option for your workflow. In the Navigation pane, click Workbook & Sheet icon, and you can see all the opened workbooks are listed into the list box, you can switch between them quickly and conveniently. If you already know a thing or two about it, then you can use macros like the following to move around your Excel workbook. Click to free trial them ! When working on Microsoft Excel, especially when it is a work-related file, the spreadsheet comprised of a lot of data along with many worksheets to switch between. Learning a few more essential shortcuts can help improve your productivity. create a VBA macro or script to automate that process, ways of sharing an Excel file with your colleagues, 7 Things To Bear In Mind When You Compare New Internet Providers, 5 Free Online OCR Services Tested and Reviewed, How to Convert a PDF File to Word, Excel or JPG Format, How to View Your Credit Report and Credit Score for Free, How to Check if Your VPN Connection is Actually Encrypted, How to Record Skype Calls on Windows, Mac, iPhone and Android, How to Embed Google Forms on Your Website, How to Sync Two Folders in Real Time in Windows, How to Use Compare & Combine Documents in Word, How to Setup an FTP Server in Windows using IIS, How to Make a Custom Discord Status With YouTube, Twitch, and More, In order to move one sheet to the right, hold down, In order to move back or one sheet to the left, hold down. For example, it will save you time while navigating Excel, or doing such routine tasks like changing row height and column width in the program. In order to move to a different space of your workbook using the Go To command, follow these steps: This will take you to the place you’ve chosen by moving the active cell box onto that specific cell. Always looking out for new ways to make her life and location-independent lifestyle easier, she hopes to share her experiences as a tech- and internet-addict through her writing. Type it in under. If you don’t want to jump to a specific cell in a different worksheet, but just want to open the whole thing, you can also use the Go To command to do it. Save 50% of your time, and reduce thousands of mouse clicks for you every day! Click Kutools > Navigation, see screenshot: 2. However, automating your everyday workflow is the first and probably the most important step you can take diving into the world of Excel. Copyright © 2007-2020 Online Tech Tips.com, LLC All Rights Reserved. Then click OK button, and you can see the Switch Windows command has been displayed in the Quick Access Toolbar, and you can switch between the workbooks easily with one click. In our daily work, we may work with multiple workbooks, to toggle between two workbooks may be easy for us, but, if there are multiple opened workbooks needed to be switched between from time to time, how could you switch between these multiple opened workbooks? There is a command called Switch Windows in Excel, by using it, you can quickly switch between multiple workbooks. In case you can’t use your mouse or touchpad or have a big workload and don’t waste time on that, you can switch between sheets in Excel using a keyboard shortcut. Switch between multiple opened workbooks with Office Tab. With a background in Journalism, Language Studies, and Technical Translation, Anya couldn't imagine her life and work without using modern technology on a daily basis. Or simply follow these steps to switch between sheets in the workbook: That’s just one example of a useful keyboard shortcut for Excel. So you’ve got an Excel document in front of you with multiple worksheets. Holding the Ctrl + Tab keys together can help you move from one window to the next window, if you have only two windows, this method will be faster.