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?
![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-3.jpg)
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:![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-4.jpg)
How to hide a sheet?
![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-5.jpg)
Right-click on the sheet you want to hide: choose "Hide".
![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-6.jpg)
The “Sheet1” is no longer visible.
How to display a sheet?
![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-7.jpg)
Right-click on a workbook sheet: choose "View".
![Excel tutorial: How to hide and unhide elements?](/images/posts/f58d298f1176a40441ad8e7c625e066c-8.jpg)
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.