3 Tips to Hide Excel Data from Nosy Co-Workers (The Nice Way)
Вставка
- Опубліковано 7 вер 2024
- Full Excel Macro Course [On Sale!]: www.teachexcel...
Download the File: www.teachexcel...
3 ways to hide data, charts, and more in Excel in a non-destructive and easy-to-use manner.
This is especially useful when you want to send a file to someone and have them focus on a specific subset of the data instead of them getting lost in the confusion of a big Excel workbook.
Resources:
Hide Columns (VBA for Microsoft Link): learn.microsof...
Hide Cells (Microsoft Link): support.micros...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel
Hello, How do I hide rows based on a cell value (in a drop down menu) without macros, like filtering? Conditional formatting only seems to white out the font but does not hide the actual row. Filtering requires to many steps by the user. I have excel 2016, What version and step do I need to take? Thanks