How to Hide and Unhide Data in Excel
Want to hide your data in Excel? Often, when we share our spreadsheets we have information that isn't for everyone. That could be...
Contact information (phone numbers, email address, address)
Personal information (social security, payment information, DOB)
Business information (revenue, sales data, payroll, costs, financial data)
Here's how to hide your data in Excel 👇
1. Select your data
2. Format cells
3. Change type to ;;; (data content will still appear in the function area)
4. Select your data and select Format Cells - Protection
5. Check the locked and hidden boxes
6. Protect sheet
How to unhide your data in Excel 👇
1. Highlight your data
2. Select Protect and click Unprotect
3. Format cells - Number
4. Change type back to General
LIKE 👍 + SUBSCRIBE for the Best Excel Tips
Want to download amazing Excel templates? Try 5 templates for FREE! 😎
🔗 https://www.simplesheets.co/
Simple Sheets Facebook 🔗: / simplesheetstm
Simple Sheets YouTube 🔗: / simplesheets
Simple Sheets Instagram 🔗: / simple_sheets
#hidedataexcel #unhidedataexcel #excel
...
GET ACCESS TO 100+ Dynamic Excel Spreadsheet Templates
🔗 https://www.simplesheets.co/
Project Management 📰
Marketing 📊
Supply Chain and Operations 🚚
Small Business 🦾
Human Resources 👨🏾🤝👨🏼
Data Analysis 👨🔬
Accounting 🧐
Finance 💵
These templates empower you to use Excel to streamline all your personal and business needs.
🦄 Customizable
🧨 Dynamic
🎨 Designed
🏭 Formatted
👩🏫 Instructions and Videos
📈 Reporting Visuals
Get 5 FREE Templates When You Sign Up 👇
🔗 https://www.simplesheets.co/kanban
🔗 https://www.simplesheets.co/plan-do-c...
🔗 https://www.simplesheets.co/gantt-chart
🔗 https://www.simplesheets.co/saas-metr...
Want to 🔐 new skills that improve your income, marketability, and expertise?
Our Excel University has 48+ lectures to help you master Microsoft Excel.
🔗 https://www.simplesheets.co/excel-uni...
We'll walk you through everything you need to know to be an Excel Expert 🏆
🔎 Lookups
🔨 Functions
🧪 Formulas
📊 Charts and Graphs
🔢 Dashboards
