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.

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

You don't have to add a header to every Excel worksheet individually when you can group them first.

If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu.

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

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

Tip You can also do lookups in other Excel workbooks by adding the workbook folder and file name in square brackets before to the sheet name.

It is possible to select the last sheet of the workbook in Microsoft Excel even if you do not remember the sheet name, or if you don't want the selection to be reliant on the sheet name, and adapt to ...