Hiding Data in Excel #73
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Steve
I've also found that using a simple ='sheet1'!A1 formula clicked and dragged to autofill only the rows, columns, etc I want to share onto a second sheet, then hiding and password protecting sheet 1, provides that extra security if I need to send the actual workbook rather than a pdf or print. Or copy the workbook, edit the new copy with a title so you know it's a redacted version (Sales 2019a, etc), and delete the private data. Really loving this series! Highly recommending it to friends and coworkers.
reply
I've also found that using a simple ='sheet1'!A1 formula clicked and dragged to autofill only the rows, columns, etc I want to share onto a second sheet, then hiding and password protecting sheet 1, provides that extra security if I need to send the actual workbook rather than a pdf or print. Or copy the workbook, edit the new copy with a title so you know it's a redacted version (Sales 2019a, etc), and delete the private data. Really loving this series! Highly recommending it to friends and coworkers.
reply
Nabiyah1
4:57 Actually in order to protect the Columns and Rows you do not need to print. All you have to do is protect the data at the SHEET LEVEL. You can -Protect The Sheet- the same way you protected the workbook, that way no modifications can be made. Protecting the sheet make all the data for that specific sheet a -READ ONLY- File. I hope this helps.
reply
4:57 Actually in order to protect the Columns and Rows you do not need to print. All you have to do is protect the data at the SHEET LEVEL. You can -Protect The Sheet- the same way you protected the workbook, that way no modifications can be made. Protecting the sheet make all the data for that specific sheet a -READ ONLY- File. I hope this helps.
reply
Hudba
Awsome, I didn't know you could hide sheets :o. PS: For all the people scared of leaking info, just make a copy of your workbook and delete the cells you want to keep concealed. Youre not sending the data if it is simply not there ;)
reply
Awsome, I didn't know you could hide sheets :o. PS: For all the people scared of leaking info, just make a copy of your workbook and delete the cells you want to keep concealed. Youre not sending the data if it is simply not there ;)
reply
Mohiuddin
I think it is possible to hide and protect column. For that, you have to go through almost the same process by clicking the -protect sheet-, which is next to the option -protect workbook-.
reply
I think it is possible to hide and protect column. For that, you have to go through almost the same process by clicking the -protect sheet-, which is next to the option -protect workbook-.
reply
Miss
If we cannot totally hide the columns even with the use of a password and still need to send the file in Excel form, what do we need to do? Please response. Thanks-
reply
If we cannot totally hide the columns even with the use of a password and still need to send the file in Excel form, what do we need to do? Please response. Thanks-
reply
Cole
I'm running into an issue where you can simply copy the workbook to a new file and then the user can unhide pages and reveal that data. Any suggestions?
reply
I'm running into an issue where you can simply copy the workbook to a new file and then the user can unhide pages and reveal that data. Any suggestions?
reply
Add a review, comment
Other channel videos
