Excel tutorial: How to hide and unhide elements?

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.