Select the columns you want to fix. In this case we’re selecting the header columns — those at the very top of the ...

Both Microsoft Excel and Word have an option to create Macros. We can use these Macros to display the complete file path in a Word document and an Excel spreadsheet.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.