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

How to Create a New Workbook in Excel. In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on ...

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 ...

This formula subtracts the number in workbook 2 from the number in workbook 1. Replace the workbook title, sheet name and cell to match the information you previously wrote down.

Named ranges aren't just for formulas. Here are two ways you can use named ranges to create shortcuts for quick navigation in a Microsoft Excel workbook.

Microsoft Excel's alternative to this time-saving tool is somewhat unimaginatively called "names," accessed through the name box in the top-left corner of your workbook.