Skip to content

How To Blog

  • HDG Explains : What Is a Computer Port & What Are They Used For? Networking
  • 4 Ways To Speed Up Windows 10 Boot Times Windows 10
  • How to check for Data Breaches on Google Chrome & Mozilla Firefox How-To
  • 7 Ways To Deal With Social Media Withdrawal technology
  • Google Chrome Autofill: A Complete Guide Tools Review
  • Apple iPadOS Review: First Impressions iPad
  • How to SSH to a Linux EC2 Instance from Mac How-To
  • How To Unzip & Open Files On Your iPhone Or iPad Tutorials

How to Switch Between Worksheets in Excel

Posted on October 5, 2020 By blog_786 No Comments on How to Switch Between Worksheets in Excel

Excel is a very powerful program. If you use spreadsheets a lot, learning Excel can make a huge difference. But even if you already know the basics, there are always a few more tricks that can improve your overall app experience.

One of the helpful tricks to learn is the various techniques you can use to quickly switch between worksheets in Excel. We’ll start with simple options, like doing it manually, and then gradually move on to other alternatives for more advanced users.

How to Switch Between Worksheets in Excel

Keyboard shortcuts for switching sheets in Excel

So, here is an Excel document with several sheets. When you need to switch between them, the obvious choice is to do it manually by selecting a different sheet at the bottom of the book. However, this option may not be available.

If you cannot use your mouse or touchpad, or you have a heavy workload and are not wasting your time, you can switch between sheets in Excel using a keyboard shortcut.

How to Switch Between Worksheets in Excel

There are two shortcuts you need to learn here: Ctrl + PgDn (page down) to go to the sheet on the right and Ctrl + PgUp (page up) to go to the sheet on the left. Or, simply follow these steps to switch between sheets in a workbook:

  1. To move one sheet to the right, hold Ctrl and then press the PgDn key.
  2. Press the PgDn key again to continue to the right.
  3. To move backward or one sheet to the left, hold Ctrl, then press the PgUp key.
  4. To continue to the left, press the PgUp key again.

This is just one example of a handy keyboard shortcut for Excel. Learning a few more important shortcuts can help boost your productivity. For example, it will save you time when navigating Excel or performing routine tasks such as changing row height and column width in a program.

Use Go To Command

Using the Go To command is another convenient way to navigate your Excel worksheet. You will especially love this method if you have to deal with overloaded Excel documents with a lot of rows and columns on a daily basis.

To navigate to a different location in the workbook using the Go command, follow these steps:

  • Open an Excel worksheet.
  • Select “Modify” from the menu at the top. screen.

  • Select Go To… from the drop-down menu. You will see the Go To window open. You can use this to jump from one place in a document to another.

How to Switch Between Worksheets in Excel

  • In the dialog box, find the reference string and enter a cell reference, such as “C22” or “H134”. Then click OK.

How to Switch Between Worksheets in Excel

You will move to the location you selected by moving the active cell to that specific cell.

Enable Go To With Keyboard Shortcuts

A quicker way to use the Go command in Excel is to learn the correct keyboard shortcuts for it. There are two different options here: you can press the F5 key or use the Ctrl + G keyboard shortcut to open the Go window.

Once you start using the Go To feature, you will see that it also saves all of your previous searches in this little window. This way you can find a list of all your previous cell references in the top box above the link line. A useful feature if you find yourself jumping between specific areas of an Excel document.

However, remember that this information will disappear after you close the Excel workbook. So if you think you will need it for future use, be sure to save it elsewhere before closing the document.

Switch between sheets in Excel using Go To

If you don’t want to jump to a specific cell in another sheet, but just want to open the whole thing, you can also use the Go command to do this.

To switch between sheets in an Excel workbook, follow these steps:

  • Open an Excel workbook.
  • Open the Go window using one of the shortcuts or manually.

  • In the Reference row, enter the desired sheet name along with the cell reference. For example, if you are on Sheet 2 and want to go to Sheet 3, you would need to enter “Sheet3 + exclamation mark + cell reference” in the Reference line, for example Sheet3! B5.

    The exclamation point here serves as a separator between the sheet name and the cell number, since you cannot use spaces in cell references.

  • This command will take you to another sheet and move the active cell to the selected cell. To return to the previous sheet, repeat the entire process, but change the sheet name that you enter in the Go To window.

How to Switch Between Worksheets in Excel

Use the hyperlink to change worksheets

You can navigate your Excel workbook and jump from one sheet to another using hyperlinks. There are different types of hyperlinks in Excel, and you can link to an existing file on your computer, web page, or email address.

If you want to create a hyperlink and use it to navigate to another sheet, do the following:

  • Select the location on the sheet (cell) where you want to insert the hyperlink.

  • Right-click it and select Hyperlink from the drop-down menu.

How to Switch Between Worksheets in Excel

  • From the options in the center of the box, select Document.
  • Go to the anchor line below, find the Find… button next to it and click it.

How to Switch Between Worksheets in Excel

  • In the pop-up window, select the sheet you want to link to and enter the reference to the cell where you want to move the hyperlink.

How to Switch Between Worksheets in Excel

  • After clicking the “OK” button, you will be taken to the previous window, where you can change the text of the hyperlink displayed in the document. Enter it in the “Display” section.

How to Switch Between Worksheets in Excel

You can later remove or edit this hyperlink to change its purpose or appearance.

Use VBA script to navigate sheets

While all of the above options are great for switching between Excel sheets, you may find yourself in a situation where you need more. For example, if you work with an Excel document consisting of many sheets, and you constantly need to move between them. In this case, you can create a macro or VBA script to automate this process.

Excel allows you to automate many different functions and commands using Visual Basic for Applications (VBA) scripting. It is the programming language that Excel uses to create macros.

If you are new to this topic, check out our beginner’s guide to VBA and the advanced VBA guide for MS Excel to learn all about self-programming in Microsoft Office.

If you already know a thing or two about this, you can use macros like the ones below to navigate your Excel workbook.

VBA Macro To Move Right

Sub Change_Sheets_Right () Dim SheetNum, CurrentSheet As Integer SheetNum = Sheets.Count CurrentSheet = ActiveSheet.Index If CurrentSheet

VBA Macro to Move Right

 Sub  Change_Sheets_Right  () Dim  SheetNum ,  CurrentSheet  as integer  SheetNum  = Sheets.Count  CurrentSheet  = ActiveSheet.Index If  CurrentSheet  < SheetNum  then Sheets ( CurrentSheet  +1). Activate  Sheets  (1). Select End If End Sub 

VBA Macro To Move Left

Sub Change_Sheets_Left () Dim SheetNum, CurrentSheet As Integer SheetNum = Sheets.Count CurrentSheet = ActiveSheet.Index If CurrentSheet> 1 then Sheets (CurrentSheet – 1). Activate Else Sheets (SheetNum ). Activate End If End Sub

VBA Move Left Macro

 Sub  Change_Sheets_Left  () Dim  SheetNum ,  CurrentSheet  as integer  SheetNum  = Sheets.Count  CurrentSheet  = ActiveSheet.Index If  CurrentSheet >> 1 then Sheets ( CurrentSheet  - 1). Activate Else Sheets ( SheetNum 

How to Switch Between Worksheets in Excel

Set both codes in your workbook to be able to navigate in both directions, right and left, one sheet at a time.

Become a Pro Excel user

Now you are one step closer to mastering Excel while saving tons of time and effort at work. Of course, there will always be new tips and tricks that you can learn about this software. For example, there are many ways to share an Excel file with colleagues or learn how to password protect Excel files.

However, automating your day-to-day workflow is the first and probably the most important step you can take as you plunge into the world of Excel.

What Excel automation tips do you know and use? Share them with us in the comments section below!

-

MS Office Tips

Post navigation

Previous Post: What Is a Smart TV, & Is It Worth The Price?
Next Post: What is Facebook Portal and Should You Buy One?

Related Posts

  • How to Use VLOOKUP in Excel MS Office Tips
  • How to use Sparklines in Excel MS Office Tips
  • How to Remove an Image Background MS Office Tips
  • How to Create a Flowchart in Word and Excel iPad
  • How to Completely Delete Personal Metadata from Microsoft Office Documents MS Office Tips
  • 10 Great Websites for Free PowerPoint Templates 2021 MS Office Tips

Leave a Reply Cancel reply

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

Archives

  • June 2023
  • May 2023
  • April 2023
  • 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
  • March 2021
  • 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
  • September 2018
  • August 2018

Categories

  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • Linux
  • Linux Tips
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Wordpress

Recent Posts

  • Unnecessary Windows 10 services that can be safely disabled
  • What Is Taskeng.exe and Is It Safe?
  • What is Facebook Watch and how do I use it in 2020?
  • How to add Google Forms to your site
  • What is a custom domain and how to set it up

Recent Comments

  1. How to Minimize a Windows Program to the System Tray 2023 - How To Blog on How to Fix System Tray or Icons Missing in Windows 10
  2. How can I unlock my Macbook using Apple Watch - How To Blog on How to Install Chrome OS on Macbook or iMac
  3. 4k hdmi switch with optical out - How To Blog on Is A Gaming PC Really More Expensive Than A Console?
  4. online video maker with music and pictures 2023 - How To Blog on 6 Video Editing Tips For Beginners
  5. 5 New Ways to Clean Electronics Safely - How To Blog on How to Clean Your Computer Properly, Inside and Out
  • How to Remove a Hyper-V VM Snapshot using PowerShell Virtualization
  • Apple TV Vs Amazon Fire Stick: how Is Better for Streaming? Gadgets
  • How to Transfer Bookmarks To And From All Major Browsers How-To
  • Zapier SMS: 5 Cool Things You Can Do Software Reviews
  • 6 Best Alexa Skills That Help When You’re Sick Smart Home
  • Turn Off Automatic Updates on iPhone iPhone
  • System Restore Points Missing in Windows? Help Desk
  • wifi calling not working android iPhone

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version