Excel: Unhide columns

Unhide one or more columns.

Help Centre › Building Processes

Unhide one or more columns.

Runs on: macOS and Windows only.

Add it to a process

In the process designer, open the Add step tab. Find Unhide columns under Excel › Columns, or type its name in the search box, and drag it onto the canvas.

Fields

FieldRequiredWhat it does
File pathNoEnter the file path, or use a variable such as {folders::desktop::path}\file.xlsx. Leave blank to use the workbook an earlier step opened.
ColumnsYesEnter one column name per line.
SheetYesName of the sheet in the Excel file. Supports wildcards: * matches any characters.

See all Excel steps.

Errors

ErrorDescription
File not openThe Excel file must be open
Sheet not foundThe specified sheet does not exist

Tips

  • Only previously hidden columns can be unhidden

Related functions

Get started

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or have your first automation working in 7 days.