Hi all! This is my first post, and I'm really hoping someone could help me out.
I'm a grad student and I need to print out several Excel files that have raw data on them. I want to have them print with the file path as a header automatically. I am already aware that you can change the page setup so that the header can contain the path name; however this would only apply to new files that I create. I have hundreds of already-existing files that I want to print.
I also know that you can choose the file path as a header in the Print Dialog Box each time you print. Again, I have hundreds of files and manually choosing these options for each one is very tedious (my carpal tunnel acts up!). I already tried creating a Print Preset where the header would be the path name, but the Preset doesn't "stick" (i.e. when I try to use the preset for another file, it doesn't work, the settings are the same as default).
Help!
Gia
I'm a grad student and I need to print out several Excel files that have raw data on them. I want to have them print with the file path as a header automatically. I am already aware that you can change the page setup so that the header can contain the path name; however this would only apply to new files that I create. I have hundreds of already-existing files that I want to print.
I also know that you can choose the file path as a header in the Print Dialog Box each time you print. Again, I have hundreds of files and manually choosing these options for each one is very tedious (my carpal tunnel acts up!). I already tried creating a Print Preset where the header would be the path name, but the Preset doesn't "stick" (i.e. when I try to use the preset for another file, it doesn't work, the settings are the same as default).
Help!
Gia