3 Tips to Hide Excel Data from Nosy Co-Workers (The Nice Way)

Add to Favorites
Author: | Edits: don

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 Excel (VBA for Microsoft Link)

Hide Cells Excel (Microsoft Link)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Toggle Visible Items in Excel Using a Button
Tutorial: Quickly toggle worksheet sections on or off - visible or hidden - using a button and a li...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced
Tutorial: Make a 3 minute macro execute in less than 1 second! Learn to make faster, better, and mo...
Hide Macros (VBA) from the User in Excel
Tutorial: Here is a simple way to prevent the user from seeing the macros that are inĀ an Excel wor...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course