Remove an obsolete worksheet column deliberately
Remove an obsolete worksheet column deliberately. A reporting template can retain a column that is no longer needed.
Practical guides, considered comparisons, and the numbers behind local document automation.
The Jetformat blog is a collection of document workflow tutorials, format comparisons, and credit estimates. Tutorials walk through a task; comparisons explain when operations differ; data articles show their assumptions and calculations. Updated .
115 articles · Page 12 of 15
Remove an obsolete worksheet column deliberately. A reporting template can retain a column that is no longer needed.
Remove an unused defined name from Excel. A workbook can accumulate names left over from retired reports.
Rename a worksheet for a customer handoff. A workbook's internal tab name may be unclear to recipients.
Restore a hidden worksheet column for review. A workbook received from another workflow may hide supporting values needed for an audit.
Reveal a hidden Excel row before an audit. An audit can require reviewing supporting rows that were hidden for presentation.
Separate workbook tabs into individual XLSX files. A delivery process may need separate files for the worksheets in a combined workbook.
Set a PDF title before handing it to a customer. A PDF viewer can show stored metadata instead of the filename in its title area.
Set document title and author metadata in a DOCX. A report's visible cover can disagree with its stored title or author metadata.