How to switch and move different tabs and sheets in Excel workbook:
Introduction:
Do you have a large excel workbook contain a lot of sheets? And you find it very difficult to find and search a sheet or cell which you want. Then no problem this article is very useful, no not useful even consider magical for your problem. This article is a solution of switching, movement around different sheets in a large excel workbook. In this article, we will discuss the voyage of excel sheets, movement between different sheets and cells within a workbook with different methods and shortcuts.
Following are different tips and tricks which command or make the voyage possible around the workbook.
Let’s start;
• Through keyboard shortcuts
• Through scroll button
• Through the “Go to” option
• Through VBA macros or script
ü Through keyboard Shortcuts:
The main and easiest way to excess your desire sheet is through keyboard shortcuts.
Step 1: Press and hold Ctrl + Page Up, to move left in the workbook, and sheets changed.
For example, if you are at sheet no 3 out of 8 sheets then if you press and hold Ctrl + Page Up then you automatically shifted to sheet no 2 and again doing this you will come to sheet no 1.
Step 2: Press and hold Ctrl + Page Down to move right in the workbook.
For example, if you are at sheet no 3 and press and hold Ctrl + Page Down then you automatically shifted to sheet no 4 and again doing this you will move forward toward sheet no 5.
ü Through scroll Button:
At the bottom left of the excel window, a scroll button is available which is used to move forward and backward.
• The left button command to go to the previous sheet.
• The right button shifted your last sheet or the next sheet.
Right click the bottom left corner arrows section where you use to scroll sheet tabs. Then you can select the needed excel sheet. This is very useful for documents with large amount of sheets tabs.
Note: Worksheet tab is located at the bottom, in excel 2007 scroll button also available and not available in 2019 Excel
ü Through the “Go-To” option:
The most useable technique in Excel to move around sheets or voyage of sheets is through Go To option
Step 1: Open the excel window and see the top of excel at a bar.
Step 2: Click the home page and choose the editing section.
Step 3: Select find and select the option of editing.
Step 4: Click the “Go-To” option in the drop-down window.
Step 5: Now the “go-to” window open and you saw a dialog box.
Step 6: Find a reference line and write which cell you want and press OK.
o Used “Go-To” to locate sheets in the workbook:
You’ll also be used the “ go-to” command to voyage sheets in a workbook.
Let’s see how it works;
Step 1: Firstly open the “go-to” window and find the reference line.
Step 2: Add sheet No, exclamation mark, and cell number.
For example, in the reference line write (sheet3!B5) and press OK.
o “Go-To” command by shortcut key:
There are about two shortcut keys which excel is used in excel windows.
The first key is Ctrl + G combination and the second is to press F5 normally.
Note: Go to command also store previous data which you write or used but this data store until window open. Once the window is closed the previous data do not store or show.
ü Through VBA macros script:
If you are interested in VBA macros then you can also use this for the voyage of sheets. Following codes help you to understand how you can move around the workbook.
o Voyage for Right;
Code for movement in the right direction is;
Sub Change-Sheets-Right()
Dim SheetNum, CurrentSheet As Integer
SheetNum = Sheet.Count
CurrentSheet = ActiveSheet.Index
If CurrentSheet < SheetNum Then
Sheets(CurrentSheet + 1).Activate
Else
Sheet(1).Select
End If End Sub
o Voyage to Left:
The VBA code for movement within the workbook is;
Sub Change-Sheet-Left()
Dim SheetNum, CurrentSheet As Integer
SheetNum = Sheets.Coun
CurrentSheet = ActiveSheet.Index
If CurrentSheet > 1 Then
Sheets(CurrentSheet — 1). Activate
Else
Sheets(SheetNum).Activate
End If End Sub
ü Through Hyperlinks:
You can also navigate sheets in excel by hyperlinks as well.
Step 1: Click the right mouse on the selected area where you want to add a hyperlink.
Step 2: clinks on the hyperlinks option and the window open. In this window firstly select the document option.
Step 3: And select the option which file or sheet you want to add to the cell.
Step 4: After choosing the file or sheet click the OK icon.
Your hyperlink is added correctly.
