Problem: Most of the time, I want to save or open files from a certain folder.
Strategy: Go to File, Options, Save. About half way through the first section, you can specify the default local file location.
Problem: I've been working on a file. I need to open the file location in Windows Explorer.
Strategy: A new feature appeared in Office 365 early in 2019. Go to File, Info and you can either copy the path or open the document location.
If you are in an earlier version of Excel, customize the Quick Access Toolbar and add Document Location to the QAT. While the folder path is often too wide for the box, you can right-click and copy the path.
This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.