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

Notes: If you save your range names to the workbook instead of the individual worksheets, you can create formulas that calculate your named ranges from anywhere on any spreadsheet in the workbook.

Open your spreadsheet in Microsoft Excel. Click and drag your mouse cursor across the cells you wish to name to select them. Right-click any selected cell and click "Define Name." ...

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...

Microsoft's Excel development team announced on Friday, December 4, 2020 that the beta version of LAMBDA, which allows you to define your own custom functions using Excel's formal language, has ...