4 GREAT Ways to Hide Values in Excel #shorts

In this video you'll learn 4 different methods to hide values in Microsoft Excel including a cool Excel trick you can use with custom number formatting in Excel.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[steves]

All great tips on hiding the material.
If the XLSX is shared, the problem with #1 & #2 is the user may type in those cells killing the formula.
Perhaps a 5th way is put those references on another tab, then hide the tab?

[ronaldnayman]

I like changing the font color. Easy to remember to re-highlight them back. Tks for the other 3 options.

[BenDieselBasicAutomotive]

Thanks again.... Another fruitful day... for the learning..

[chrism]

Thanks Leila. I usually just hide the row

[aliasgarrampurawala]

All the ways are very useful
We need to use as per requirement of sheet and their viewer audience

[mattnyman]

My current method tends to be to change the font to the lightest gray so that they don't attract the attention of the high level audience but also are there for anyone who wants to review formulas.

[samrathna]

I would use ;;;
That’s something new I learned today.

Love your work Leila

[ricorico]

I didn’t know about the three semicolons … great Leila, thanks!

[osoriomatucurane]

My favorite one would be masking (customer formatting). However, like many motivated comments here, the best one goes along with the circumstances (who are the stakeholders that are engaged as the end users)

[monzon]

Thank you as i start learning more about excel

[shelkarumesh]

Thanks, I am learning quiet interesting tips. Last one is great

[tastyjay]

Never heard of the ;;; tip before. Thanks!

[shankarbhardwaj]

My favourite is the easiest option, which allows other people to figure out what is going on (therefore grouping!)

[MunchWillbeBlue]

Add a new tab, copy and paste the row over, select it and make it a named range. adjust the formula's to use the named range. hide the tab that contains the named range, delete the original row.

[MoodyAlshehaby]

all good, but 4th one was new to me, so I like it. thanks.

[reptilezsweden]

For my own files I prefer grouping. For locked documents that others will use I just hide the row (height=0). For unlocked shared documents I just make them light grey so that people see that there is something there and don't remove it by mistake.

[giorgidvali]

cool, usefully advices, thank you so much, for Smart videos

[tazguy]

Good tips! I wouldn't group the rows, personally, as it's hard to hide the grouping from the user. I like it, though.

[-UsernameNotFound]

Scroll them above the column headers and freeze panes

[RA-rhlb]

Grouping is the better option because its more visible that things have hidden from the clutter ..