HomeHow to GuidesHow to Create a Clickable Next Button in Microsoft Excel

How to Create a Clickable Next Button in Microsoft Excel

Published on

You must do something different to make your spreadsheet appealing or stand out. The clickable Next button in Microsoft Excel means you can move to the next spreadsheet with a click of a button in a workbook containing multiple worksheets.

Why a Clickable Next button in Microsoft Excel is Relevant?

You can move to the Next worksheet by clicking on the sheet tab name or using the shortcut key “Ctrl+Page Down” or “Ctrl+Page UP.”

But sometimes, when the number of tabs is more, all sheet tabs may not be visible. So the best way to move to the next sheet is to show the Next and Previous Buttons in your spreadsheet.

Let’s see how to create a clickable Next button in Microsoft Excel which is very easy.

How Can We Create a Clickable Next button in Microsoft Excel

Steps to Create a Next Button in Microsoft Excel which is Clickable.

  • Insert a text box from the Insert Menu.
  • Type “Next >” inside the text box and format it by changing the font color or filling the text box with any color.
  • Select the text box. For this click inside the text box and then click on the edge of the box.
  • Then go to the Insert menu and click on “Hyper Link”. Instead here you can use the shortcut key “ctrl+k”
  • Click “place in this document” click the sheet name under cell reference ” and click “OK”.

See the screenshot below.

Create a clickable next button in Microsoft Excel

The text box with the text “Next >” is now a clickable Next button in your spreadsheet.

A click on this button will take you to the Next linked worksheet in your workbook.

You may also like: Create a Table of Contents in Google Sheets

If you want, hide the sheet tabs from File > Options > Advanced. See the screenshot below.

show sheet tabs in excel

Untick “Show sheet tabs” under “Display options for this workbook.”

It’s not your usual hiding of sheets by right-clicking on the sheet tab names. In this, you can’t navigate to the hidden sheet by using the two shortcuts above.

Here we here are just hiding the tab names in one go. The sheets are still accessible using the shortcut keys.

If you hide the sheet tabs this way, in addition to the Next button, use a clickable Previous button from the second worksheet onwards.

So there will be two buttons from the second Sheet onwards. The steps are the same to create the Previous button.

While adding a permalink to the buttons, choose the appropriate tabs.

Hope this Excel trick is new to you. Try it and I’m sure you will find such small Excel tricks useful.

Prashanth KV
Prashanth KVhttps://infoinspired.com/about-me/
Introducing Prashanth KV: Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Creating a Running Balance with Dynamic Array Formulas in Excel

For calculating a running balance, we can utilize the SCAN function, which is a...

Comparing the FILTER Function in Excel and Google Sheets

I believe comparing the differences in how the FILTER functions work in Excel and...

Quartile IF in Google Sheets

To calculate quartiles based on conditions, referred to as "Quartile IF," we will use...

Drop Rows and Columns by Index Numbers in Google Sheets

With the help of two simple custom formulas, we can drop rows and columns...

More like this

How to Delete More Than 50 Messages at a Time in Yahoo Mail

Email accounts are a must for all of us because we can use them...

Mark the Position Where You Are in on Your Phone and Locate It Later

Going for a long walk on a sandy beach barefoot will surely increase your...

How to Set Your WhatsApp Profile Picture in Full Size

WhatsApp is continuing its success story and reached a milestone recently. It became the...

LEAVE A REPLY

Please enter your comment!
Please enter your name here