Hiding Data in Excel

[hudbaoir]

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 ;)

[cebolikajehovakhanyile]

I've been trying to do this for hours. Thanks alot

[mwwcqdt]

If you came here looking for how to hide data, right click, format cell, custom, add ;;;. For most it looks like empty cells.

[lawrencekazibwe]

It has very informative, thanks alot Boss

[AjitSingh-APS]

To hide a particular column, Profit in this case.. We can simply make a copy of this worksheet and delete the column, which we can do very quickly and share the same sheet with the concerned person, no need to use hide option or any trick. Until it is a shared excel sheet over internet, it works fine.

[belindaprimus]

Excellent teacher!!! I really want to be very proficient at excel and feel empowered by you!! Thank you.

[jeaninehaack]

Just love your tutorials!!! Thank you!

[steveharris]

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.

[Nabiyah]

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.

[PoojaYadav-pyjf]

When hiding columns or rows, instead of selecting the row or column u want to hide - right click and hide.Just select the column and drag the column you want to hide.The same can be done for rows.

[wetwater]

say im trying to hide and remove, lets say, profits from the total. how do I do that using the group method?

[thescreamthescream]

could you please please please provide us with a link to the files you work on in your videos !! yOuR ArE aWsOmE :)

[philliphenderson]

How can groups of columns or rows be hidden with a drop down menu?

[missdaraa]

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~

[colepinder]

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?

[brianprice]

I have a column in which the word SODA is in there several times. I need to know how many I have of those.