Man illustrationFlower illustration
Excel

Hide or show

Estimated reading: 2 minutes 324 views

Hide or show activity is used for hiding or showing a column or a row in an Excel file.


*Excel nameThe reference name of the excel file which has already been opened or created is chosen in the dropdown.
Sheet nameThe name of the sheet to work in Excel can be added. If not added, it is accepted as the first sheet by default.
Sheet indexIndex of the sheet to work in Excel. If not added, it takes the first sheet by default.
ActionHide and show action is chosen rows or columns.
RowsIt is written which row will be shown or hidden.
ColumsIt is written which columns will be shown or hidden.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${newExcel}

You can use the Sheet name file name as shown in the example.

Sheet1

You can use the Sheet index as shown in the example.

5

You can use the Action as shown in the example.

HIDE

SHOW

You can use the Rows as shown in the example.

1

1:5

You can use the Rows as shown in the example.

1

1:4

If the Row field is left blank, it will perform the operation for the whole column.

Share this Doc

Hide or show

Or copy link

CONTENTS
Chat Icon Close Icon