To change the height of the worksheet tabs in Excel, follow these steps:
- Click the File tab.
- Click Options.
- In the Advanced category, under Display options for this workbook, do one of the following:
- To change the height of all worksheet tabs, click Standard (sheet tabs at bottom).
- To change the height of only selected worksheet tabs, click Show sheet tabs.
OR
- In the left pane of the Excel Options dialog box, click Advanced.
- In the right pane, under Display options for this workbook, do one of the following:
- To change the height of all worksheet tabs, click Standard (sheet tabs at bottom).
- To change the height of only selected worksheet tabs, click Show sheet tabs.
OR
- Click on "Excel Options". This is located at the bottom right corner of your screen.