• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Hide Data in a Worksheet in Excel

How to Hide Data in a Worksheet in Excel

October 21, 2016

There may be times when you want to share or view some data in an Excel worksheet, but not all of its contents. In such cases, you can hide the data from view. In this Excel tutorial, I’ll show you two ways in which to hide data in a worksheet in Excel 2016.

Note: This method should not be used to hide sensitive information or hide protected information. The main purpose of this method of hiding data is to ensure that you avoid screen clutter and make the document more easy to read. Plus, its always nice to see a clean, professional looking worksheet, isn’t it?

There are actually 2 ways in which this can be accomplished. Let’s take a look at them.

How to Hide Data in a Worksheet : Method 1

In our Forecasting Figures, let’s hide the Pessimistic and Optimistic revenue figures.

data-to-hide

1. Open the worksheet and select the rows or columns of data you want to hide. We’ll select the columns D and E.

2. Right-click the selected rows or columns and from the contextual menu, select Hide.

how-to-hide-data-in-a-worksheet-method-1

That’s it! The selected rows and columns will disappear from view. You will notice that the column or row headers are missing a few Row numbers or Column Letters and there’s a double-line over the hidden rows or columns.

hidden-columns

Should you want to bring back the items you hid previously, you can select the row or column headers adjacent to the hidden ones, right-click the selected columns and from the contextual menu, select Unhide. You can also click and drag the double line over the hidden rows/columns to bring all the hidden rows and columns into view.

ALSO READ:  How to Insert a Tick Mark in Microsoft Word and Excel

How to Hide Data in a Worksheet : Method 2

In the first method of hiding data, all your row and column data will be removed from view. Maybe, that’s not what you want. Maybe you want only some part of the data to be hidden from view. In such a case you can use this method. Let’s hide only the Optimistic revenue figures.

1. Select the range of cells you want to hide. I’ll select the range E1:E21.

2. On the Home tab, in the Font group, click the Font Color drop-down button and select the White color font.

How to Hide Data in a Worksheet in Excel method-2

The data you selected is now invisible to the eye. However, you need to remember that the data is still there and if you select a cell with the white font, you will be able to see its contents in the Formula bar.

If you want to display the data again, simply select the cell range ( or the entire worksheet area) and change the font color to black.

One of the dangers of hiding data this way is that should the data be shared with another user, they may easily overwrite the contents by accident. Therefore, make sure you protect your worksheet data by following the steps in this tutorial, which is a safer option.

If you found this tutorial helpful, be sure to check out more good stuff in our Learn Excel series. If you want to learn Excel from scratch, consider taking up our Udemy course, Excel 2016 for Beginners. It is available at a nominal price of just $10.

Tweet12
Share2
WhatsApp
Pin7
Buffer
21 Shares

Filed Under: How To Tagged With: excel how to, learn excel

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazfit Falcon Smartwatch - TATFI

The Amazfit Falcon is a Military Grade Smartwatch with Premium Looks and Great Features

Couchmaster Cyboss Ergonomic Couch Desk - TATFI

Couchmaster Cyboss is an Ergonomic Desk to Keep Off Neck Pain

Philips Hue Festavia String Lights - TATFI

Add a Bit of Sparkle to Your Christmas Tree with Philips Hue Festavia String Lights

Samsung Galaxy Tab A7 Lite Kids Edition - TATFI

This Kid Friendly Tablet from AT&T is a Thoughtful Gift for Your Little One This Christmas

Is An iPhone Really Worth It - TATFI

Is an iPhone is Really Worth It?

Devices You Might Want to Try - TATFI

4 Fantastic Devices You Might Want to Try

Amazon Kindle 2022 - TATFI

Meet the Amazon Kindle 2022 – Packed with New Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Make Money Playing at Fairspin Online Casino - TATFI

Make Money Playing at Fairspin Online Casino

How Mobile Wellbeing Apps are Empowering Patients - TATFI

How Mobile Wellbeing Apps are Empowering Patients

Tips to Boost Your Ranking and Sales on Etsy - TATFI

5 Ways to Boost Your Ranking and Sales on Etsy

PunchBee Time Management App - TATFI

Know How You Spend Your Time with PunchBee

DevOps Model Explained - TATFI

The Complete Guide to DevOps: How the Model Works and Who It Benefits

Approaches to Digital Marketing - TATFI

Blending Technical and Content-Centric Approaches to Digital Marketing

Tech Tips For Startups - TATFI

Useful Tech Tips For Startups

Boox Tab X Android eReader - TATFI

Boox Tab X is an Android eReader That Helps You Do More Than Just Read

Best e Readers to Buy in 2023 - TATFI

5 Best eReaders to Buy in 2023

Best Translation Apps for Android - TATFI

5 Great Translation Apps for Android

Dynamic Island Feature on Your Android - TATFI

How to Get the Dynamic Island Feature on Android

Connected TV Advertising In 2023 - TATFI

5 Things You Need To Know About Connected TV Advertising In 2023

TheAppTimes © 2023 // Runs on StudioPress