Excel tutorial: How to hide and unhide elements?

Who I am
Joel Fulleda
@joelfulleda
Author and references

PixieMe / Shutterstock.com
For security or anonymity reasons, you may need to hide certain elements of your workbook. Here are some examples that will be very useful to you.

How to hide a column?


Right-click on the column (here B) and choose "Hide".


Column B is no longer displayed in your sheet.

How to show a hidden column?


Select the two columns 'surrounding' the column to display (here column A and C): choose “Display”.

How to hide or show a line?

The principle is identical to the columns:


How to hide a sheet?


Right-click on the sheet you want to hide: choose "Hide".


The “Sheet1” is no longer visible.

How to display a sheet?


Right-click on a workbook sheet: choose "View".


All you have to do is select the sheet you want to display in your Excel workbook.

40 ">This tutorial is brought to you by the trainer Jean-Philippe Parein
Find his course Learn and master Excel from A to Z
in full on Udemy.
add a comment of Excel tutorial: How to hide and unhide elements?
Comment sent successfully! We will review it in the next few hours.