Redact spreadsheets cell by cell, and send back a spreadsheet
A pupil list or a payroll export no longer has to go out as a PDF print of the sheet. Redact it in a grid, and the requester gets a .xlsx.
The grid
An attached spreadsheet opens in a grid on its own tab beside the message in Redact.
How attached files are listed and convertedSelect and press R
Redact cells, ranges, rows, columns, a whole sheet, or a sheet’s name. Add a reason as you go, or remove and undo.
Looks like the file
The file’s column widths, merged cells and number formats, with freeze panes, wrap text, a cell bar, and columns you can resize or fit to their contents.
Counts you can check
The file’s row in the list shows how many cells are redacted and from how many redactions.
Terms and split names
The words you have already redacted across the project reach the spreadsheet too.
Terms marked in the grid
Words you redacted with Search & Redact or a word list are marked in the cells that hold them, and the whole cell is redacted.
Names split across cells
A name printed across a Forename and a Surname cell is found and redacted too.
Wrapped cells read whole
Text that wraps over several lines in a cell is searched as one value.
The .xlsx export
A rebuilt .xlsx
Cell values, formatting and layout, with every redaction blacked out. The requester can open it in Excel like the original.
_REDACTED only when it is
The file is named _REDACTED only when something in it was redacted.
Beside its message
It sits next to the message it came with in the export ZIP, like any other attached file.
The PDF fallback
If you need it, Redact on the PDF view instead opens the spreadsheet as its converted PDF. Redactions made there send the file to the export as its PDF rather than a .xlsx.
Questions
Send back a spreadsheet, not a print of one
Upload the mailbox the spreadsheet came in, approve its message, and redact it cell by cell.