Once you know what macros you'd like to set up and have the Developer tab ready, here's what to do in Excel on Windows or macOS: Click the Developer tab and find the Code group.

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.