First, make sure you are viewing the worksheet, not editing the cell contents.
In the tab bar at the bottom of the worksheet, right-click the name of the tab you want to resize.
In the pop-up menu, select the label color option.
In the pop-up dialog box, you can select the font tab and then adjust the font size there.
Through these steps, you can easily adjust the font size of worksheet labels.