Hide Sensitive Data in Excel using REPT Function

Hide Sensitive Data in Excel using REPT Function is a video demonstration that will help you understand how to hide sensitive data in excel and protect it.

By the end of this video, you should be comfortable to:

1. how to use REPT Function in Excel
2. how to use LEN Function in Excel
3. How to Hide Sensitive Data in Excel
4. How to protect sensitive data in Excel

Use the following link to download the copy of the workbook used in the demonstration.

In case you are stuck, add your questions below in the comments section, and I will be happy to help you.

I hope that you're enjoying learning Excel through this Excel learning series with Syed. I request you to share these videos with anyone who desires to learn Excel from scratch.

Kindly subscribe to the channel and enable notifications by clicking on the bell icon to receive updates about new videos as and when they are added to keep up with Excel Learning.

Applies to:
Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365 and above

#excelLearningSeries #excel #excel2016 #HowWeExcel #exceltips #office365 #excel2019 #excelcalculations #secure #dynamic

[stanulli]

But I can extract in the column to the right and type the hidden alphabet and row number and I will be able to see.

[muhammad]

yh I did this, but then copy pasting to a new sheet and can unhide the salary

[AvneetKaur-lelk]

If I copy paste the sheet to new excel, I will be able to unhide the column. How to prevent that