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

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.

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

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

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.

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