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

You can show File Path on Title Bar in Excel and Word by creating and running a Macro - and even in Quick Access Toolbar too. This post explains the process in detail.

Save the worksheet as an Excel file. Open the CSV file again, select Developer>Macros, select the BranchCSV macro from the list, and click Run. The entire worksheet is organized in one second.

Now that you have enabled Macros in your Excel file, you can create your own macros if you use a repetitive task in Excel and want to facilitate it. To record a macro, go to Developer tab and choose ...

Macros in Microsoft Office are blocked for security reasons, but you can enable and use signed macros. This tutorial explains how to create a self-signed digital certificate.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.