I would suggest creating a macro to hide the unwanted columns, print
the sheet and then unhide the columns. Simpler than trying to maintain
a copy.

But if you want to make the formula version work, select the entire
column and array-enter (using Ctrl+Shift+Enter): =DOI
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup