Posts

Showing posts with the label Quick Access Toolbar

Quickly locate active workbook's folder

Image
Excel Tip #019 Quickly locate active workbook's folder We will be working on (or) will be having multiple workbooks open at a time. Sometimes I want to know the folder location for the file that I am working on. And sometimes I need to go to that folder to access other related files. A cool trick that I find handy involves adding the Document Location command to my Quick Access Toolbar (QAT) . Add the Document Location command to your QAT Right click anywhere on the Ribbon and select " Customize Quick Access Toolbar " On the " Choose commands from " dropdown, select All Commands In the list of commands (on the left side of the dialog), scroll down and select the Document Location command Click the Add>> button and click OK Document Location command in QAT Note : You can see the document location (or) the folder path only if the workbook is saved The " Document Location " command is not only useful to show the full pat...