How to open an opened file in Finder
I say that depends on the program you open the file with, but in most programs you can right-click the file name in the top bar, click the containing folder, and a new Finder window will open with the file already selected: