Follow these steps to increase the height of the worksheet tab in excel
Set a column to a specific width
Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click Column Width.
In the Column width box, type the value that you want.
I hope this helps!