Skip to content

How To Blog

how to

  • How to Use Apple Watch Blood Oxygen Sensor Apple Watch
  • How to Customize the Ribbon in MS Office Office Tips
  • Firefox Containers: Use Them to Organize Your Online Life Computer Tips
  • How to Run 2 Whatsapp in one Phone How-To
  • CD/DVD Drive Missing in Windows? Help Desk
  • Three Unique, Free Fitness Apps to Get in Shape With for 2019 Software Reviews
  • How To Automate The Boring Stuff – 6 Hacks To Make Life Simple How-To
  • How to Reset or Unfreeze an iPad or iPhone Tutorials

How to Switch Between Worksheets in Excel

Posted on October 5, 2020 By 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 Remove an Image Background MS Office Tips
  • Use the Excel Watch Window to Monitor Important Cells in a Workbook MS Office Tips
  • How to Forward Outlook Emails to google mail MS Office Tips
  • best powerpoint tips to improve your presentations MS Office Tips
  • How To Add Audio Narration To a Powerpoint Presentation MS Office Tips
  • How to Compare Two Excel Files 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

  • baby monitor app android How-To
  • What Is HDR On An iPhone Camera? iPhone
  • Change or Spoof a MAC Address in Windows or OS X Computer Tips
  • How to Enable Mac Firewall and Configure It OS X
  • HDG Explains : What Is Bandwidth? Networking
  • How to Fix Internet Explorer has Encountered a Problem and Needs to Close Method
  • Best Salary calculator Information discussion Websites

    Why negotiate a salary? On the one hand, the negotiations are working. Displaying the skills and values ​​that you add to the table, as well as a carefully thought-out pause after the offer, can lead to increased profits. Whether you are weighing a job offer or looking to get a promotion, negotiation is key. Best...<p class="more-link-wrap"><a href="https://blog.pkrtousd.gb.net/best-salary-calculator-information-discussion-websites/" class="more-link">Read More<span class="screen-reader-text"> “Best Salary calculator Information discussion Websites”</span> »</a></p>

  • What Does SMH Mean (And How to Use It) technology

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