How to use hyperlinks to move quickly between sheets in Microsoft Excel


The busier a Microsoft Excel workbook is the more ways you need to get around in it. Check out these shortcuts to help you move between sheets.

Microsoft excel on smartphone screen and Microsoft excel logo background : Chiang Mai, Thailand, January 9, 2022
Image: Sai/Adobe Stock

Moving around a Microsoft Excel workbook isn’t difficult if you have only a few sheets. That’s because Excel displays sheet tabs at the bottom of the screen. Simply click a tab to activate that sheet. The more sheets you add, the greater the chance that Excel will push some sheet tabs out of sight.

When that happens, you don’t need fewer sheets, you need more ways to access sheets. In this tutorial, I’ll show you several ways to quickly move from sheet to sheet in an Excel workbook.

I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use older versions of Excel and Excel for the web.

SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic)

How to use shortcuts to move in Excel

The default number of sheets in an Excel workbook is three, but there’s no limit to the number of sheets a workbook can have. Your system’s memory might limit the number of sheets, but Excel won’t. With no limit, moving around a busy workbook can quickly become tedious. Fortunately, Excel offers shortcuts.

Moving between the first few sheets is easy. Simply click a tab at the bottom of the screen (Figure A). There’s one big inherent problem with this method: You can’t click tabs you can’t see. Moving to another sheet is no longer a quick click, but it still isn’t difficult.

Figure A

Selecting the tabs in Excel to move between sheets
Figure A: Click a tab to move to another sheet.

To the left, you can click the back and forward arrows (circled in Figure A). For each click, Excel moves the tabs one sheet to the left or right, exposing tabs you might not otherwise see. If your workbook has dozens of sheets, this method isn’t particularly helpful because it could take several clicks to reach the sheet you want.

Using the sheet list is a quicker method. To do so, right-click the back and forward arrow area to display a list of sheets (Figure B). Click a sheet to activate it immediately. If the dialog can’t display the complete list, Excel will add a scroll bar to the right. Even if you must scroll through dozens of sheets, it’s still quick.

Figure B

Activate menu in Excel.
Figure B: Use this sheet list to quickly activate a sheet.

The sheet list might become your best friend if you must move around numerous sheets in the same Excel workbook. There are shortcuts you might also find useful:

  • Move to the first sheet: Press and hold Ctrl and click the left arrow.
  • Move to the last sheet: Press and hold Ctrl and click the right arrow.
  • Move one sheet to the right: Ctrl + PgDn. Continue to hold down Ctrl and press PgDn to continue moving to the right.
  • Move one sheet to the left: Ctrl + PgUp. Continue to hold down Ctrl and Pres PgUp to continue moving to the left.
  • Move to a specific sheet: Press F5 to open the Go To dialog. The Reference setting will display the active sheet and cell. Overwrite it (Figure C), and click Go. The required exclamation mark is a separator between the sheet and cell reference. The only advantage to this method is that it also activates a specific cell.

Figure C

Creating a reference between sheets in an Excel workbook.
Figure C: Use Go To when you want to specify the sheet and cell.

How to use hyperlinks to move in Excel

Hyperlinks are a type of shortcut that requires only a quick click. If you find moving around using tabs and keyboard shortcuts a bit tedious, you might try hyperlinks. A hyperlink is specially formatted content that responds to a click by opening a file, a web page or moving the cursor to another location in the same file.

To demonstrate, add hyperlinks to a sheet one at a time. First, click the Insert tab, and click the Link dropdown in the Links group. From the dropdown, choose Insert Links at the bottom of the list.

In the resulting dialog, click Place in This Document in the Links bar (to the far left). In the Or Select a Place in This Document list, click the sheet to which you want to link (Figure D).

Figure D

Insert Hyperlink menu in Excel
Figure D: Select a sheet.

Click OK to return to the hyperlink shown in Figure E. Simply click the hyperlink to immediately activate Sheet4.

Figure E

hyperlinked sheet reference in Excel
Figure E: Excel inserts a hyperlink to the selected link.

Stay tuned

Chances are you will want a full list of sheet hyperlinks. In a future article, I’ll show you how to create a quick list of hyperlinked sheet names using Microsoft Power Query.



Source link

istanbul escort aksaray escort arnavutköy escort ataköy escort avcılar escort avcılar türbanlı escort avrupa yakası escort bağcılar escort bahçelievler escort bahçeşehir escort bakırköy escort başakşehir escort bayrampaşa escort beşiktaş escort beykent escort beylikdüzü escort beylikdüzü türbanlı escort beyoğlu escort büyükçekmece escort cevizlibağ escort çapa escort çatalca escort esenler escort esenyurt escort esenyurt türbanlı escort etiler escort eyüp escort fatih escort fındıkzade escort florya escort gaziosmanpaşa escort güneşli escort güngören escort halkalı escort ikitelli escort istanbul escort kağıthane escort kayaşehir escort küçükçekmece escort mecidiyeköy escort merter escort nişantaşı escort sarıyer escort sefaköy escort silivri escort sultangazi escort suriyeli escort şirinevler escort şişli escort taksim escort topkapı escort yenibosna escort zeytinburnu escort porno 1080p porno izle 4k porno izle 720p porno izle abella danger alman alman porno alman porno izle aloha tube porno amatör amatör porno amatör porno izle anal anal porno anal porno izle arap porno asa akira porno asyalı porno bangbros porno bangbros porno izle banyoda sikis başörtülü porno beeg porno izle beyaz tenli porno izle biseksuel porno izle bisexsuel porno brandi love porno brazzers brazzers porno izle canli porno canli porno izle çinli porno çinli porno izle ensest porno ensest porno izle ensest seks erotik porno erotik porno izle esmer porno esmer porno izle etek altı fake agent fake taxi fake taxi porno fantazi pornoları fantezi porno izle fetiş porno fetiş porno izle fetish fransız porno fransız porno izle full hd hg porno izle gangbang porno genç kız porno izle genç kız sikişi genç teen porno izle gizli çekim porno gizli çekim pornosu grup pornosu grup porno grup porno izle hd pornolar hd porno hd porno izle hemşire porno hemşire pornosu hizmetçi porno hizmetçi porno izle ingiliz porno japon pornoları japon porno kızlık bozma kızlık bozma porno izle konulu porno konulu porno izle koreli porno köylü pornoları kumral porno kumral porno izle latin pornoları latin porno latin porno izle lezbiyen pornoları lezbiyen porno lezbiyen porno izle lisa ann porno liseli pornoları liseli porno liseli porno izle manken porno manken porno izle masaj porno izle masturbasyon porno izle masturbasyon pornoları mature porno mia khalifa porno mia malkova porno milf porno izle mobil porno mobil porno izle öğrenci porno izle öğretmen porno izle okul porno izle olgun kadın pornosu olgun porno oral porno oral porno izle oral seks porna izle pornhub pornhub porno izle porno film izle porno indir porno izle porno resimler porno star porntube porno izle redtube redtube pornoları riley reid porno rokettube rus pornoları rus porno rus porno izle sakso blowjob porno izle sarışın pornoları sarışın porno sarışın porno izle sarışın pornoları sekreter porno shemale sikiş sikiş sikiş izle şişman porno siyahi pornoları suriyeli pornoları swinger porno tecavüz porno teen porn türbanlı pornoları türbanlı porno türk pornoları türk porno türk porno izle türkçe altyazılı porno türkçe altyazılı porno izle xhamster pornoları xhamster porno xhamster porno izle xnxx xnxx porno xnxx porno izle xvideos xvideos porno izle yaşlı porno yeşilçam porno izle youjizz youporn youporn porno izle zenci porno güvenilir bahis siteleri bahis siteleri casino deneme bonusu casino siteleri deneme bonusu para yatırma bonusu bahis siteleri casino siteleribahis sitesi para yatırma