Create Clickable Tabs Inside an Excel Sheet

Why It Matters

Embedding clickable tabs transforms Excel into an interactive reporting platform, allowing business users to explore monthly data instantly and improve decision‑making speed.

Key Takeaways

• Convert data to an Excel table before creating clickable tabs.
• Use named cells and shapes to act as dynamic month selectors.
• Apply FILTER formula linked to selected month cell for auto-updating data.
• Implement VBA macros to change tab colors and refresh displayed values.
• Alternative hyperlink method works without code but requires separate worksheets.

Summary

The video demonstrates how to build fully clickable, color‑changing tabs inside a single Excel worksheet, turning a static table into an interactive budget dashboard.

The process starts by converting raw data into an Excel table (Ctrl T), naming a cell “selected_month”, and inserting rounded‑top shapes for each month. The shapes are aligned, distributed, and labeled, then linked to a FILTER formula that pulls rows where the month column equals the selected_month cell, automatically updating the displayed data.

VBA code is introduced to handle tab selection: each shape is given a name (e.g., tabJanuary) and assigned a macro that changes the shape’s fill color and writes the month name into the selected_month cell, causing the FILTER output to refresh. An alternative, code‑free solution uses hyperlinks to jump between hidden sheets, mimicking tab behavior.

By embedding this functionality directly in Excel, analysts can create sleek, self‑service dashboards without resorting to external BI tools, speeding up month‑over‑month reporting and reducing manual filtering errors.

Original Description

How to create clickable tabs inside a single Excel sheet.

Take our Data Analyst Program here: https://www.careerprinciples.com/career-track/the-data-analyst-program

🆓 DOWNLOAD the Free Excel file and VBA code for this video: https://careerprinciples.myflodesk.com/wdii7z8ze3

in this video, I'll show you how to create tabs inside an Excel sheet that are fully clickable, change colors when selected, and the corresponding data updates automatically. This way you don't need to have dozens of worksheets; instead, have everything in one sheet with multiple tabs. For this, we'll be using shapes, named ranges, and the filter function to dynamically change the results when we click on a certain month. To tie this all together, we'll be using VBA code to create macros for each of the tabs. I'll also show you a no-code alternative using hyperlinks in Excel.

LEARN:

👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance

📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course

🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics

🚀 All our courses: https://www.careerprinciples.com/all-courses

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:

0:00​ -​ Page Setup

2:52​ - Dynamic Formula

4:25​ - VBA Code Solution

7:30​ - Changing the Number of Tabs

9:30​ - Page Formatting

11:27​ - No-Code Alternative