gaqsingapore.blogg.se

The procedure to create a Macro for displaying the complete file path in Title Bar is different for Excel and Word. We can use these Macros to display the complete file path in a Word document and an Excel spreadsheet. After that, you just have to run the Macro, and Word and Excel will display the complete file path of the opened document and spreadsheet in the Title Bar. We have explained the entire process in detail in this post.īoth Microsoft Excel and Word have an option to create Macros. After that, save it as an Excel Macro-Enabled Workbook for Microsoft Excel Spreadsheet and a Word Macro-Enabled Document for Microsoft Word. First, enable the Developer tab, then create a Macro. You can display the file path in Title Bar in Word and Excel by running a Macro. If you know this trick, you will be able to display the file location for a particular Word document or Excel spreadsheet on the Title Bar so that you could locate it easily. This trick is useful if you have many documents or spreadsheets saved in different locations on your system. We save our Word documents and Excel spreadsheets in different locations on our hard drives. In this article, we will learn how to show the File Path in Title Bar in Excel and Word. But Excel or Word does not display the file path or file location on the Title bar by default. When we create a new document or spreadsheet, its default name is shown on the Title Bar. When we open a document in Word or a spreadsheet in Excel, its name is displayed on the Title Bar of Word and Excel respectively.