Question

Why hide & unhide option is used in
spreadsheet?​

Answer 1

Answer:

The Hide/Unhide option is used in a spreadsheet to temporarily hide or remove a row or a column.

This option is available under Home tab, Cells group and Format button.

By right clicking, we can get thi option too.

The different components of Hide option are as follows:-

• Hide rows: This helps in hiding rows.

• Hide columns: This helps in hiding columns.

• Hide sheet: This option helps in hiding the whole sheet.