To create a new sheet, right-click on any existing worksheet name and click on "Insert," then select "Worksheet." Alternatively, you can press Shift+Alt+F1.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

In this article we will show you how to add a sheet to an Excel workbook using VBA. There are 2 different methods detailed below in order to do this.

How to create an automated list of worksheet names in Excel -- and add a table of contents.