I need to make the same changes to multiple spreadsheets over time. The clipboard forgets or deletes its contents when I close Excel. Is their any way to save the contents of the clipboard for the next time I need to change them?
-
Sounds like a usage case for a clipboard manager or different usage behavior. If you need to copy and paste between multiple spreadsheets open multiple instances of excel.– RamhoundJan 2, 2015 at 18:54
-
As said here, Excel doesn't support doing this, so you will have to use a clipboard manager unfortunately.– ᔕᖺᘎᕊJan 2, 2015 at 18:57
2 Answers
One clipboard manager I use is Clipjump, http://www.portablefreeware.com/?id=2523, but there are a slew of them available. They allow you to save a number of items from the clipboard, so it might simplify your Excel use.
You may find the clipboard pane useful. It will collect anything you copy to a list that carries over across all MS Office programs. With this enabled, the last several copies should remain there even after exiting Excel.