1.

How to Unhide a Sheet Tab in Excel (7 Methods)

Method 1 - Using View Tab Suppose you have a workbook where the sheet tabs are accidentally hidden. To restore them, follow these steps: Go to the View tab. Select Unhide Window. In…

2.

How to Create Tabs Within Tabs in Excel (With Simple Steps)

  Steps to Create Tabs Within Tabs in Excel In this tutorial, we will create tabs within tabs to show detailed statistics of three football clubs. The dataset contains data about the…

3.

How to Put Excel Tabs on Top of Worksheet (2 Easy Ways)

Here's a GIF overview of how to access worksheets from the Quick Access Toolbar (QAT) which are added in QAT using VBA code. Method 1 - Using VBA to Put Excel Tab…

4.

How to Create Tabs Automatically in Excel (3 Cases)

Opening new tabs one by one and naming them in Excel is tedious and time-consuming. But we can create tabs automatically using VBA codes. In the GIF below, cells C6:C8 contain employee…

5.

How to Change Worksheet Tab Color in Excel (3 Handy Ways)

In many cases, we may need to add or change the worksheet tab color in Excel. This helps you identify any worksheet very easily. Also, adding or changing worksheet colors helps categorize…

6.

How to Group Tabs Under a Master Tab in Excel (2 Ways)

In this tutorial, we will group tabs under a master tab in Excel using hyperlinks and VBA. In the master sheet provided below, the sales records of each employee are conveniently linked…

7.

[Fixed!] Excel Sheet Tabs Hidden behind Taskbar: 6 Solutions

Method 1 - Maximizing Excel Window One common reason sheet tabs are hidden behind the taskbar is that the Excel window is not at its maximum size. You can see that the…

Advanced Excel Exercises with Solutions PDF