From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Restore missing labels and hide repeating labels

Restore missing labels and hide repeating labels

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Restore missing labels and hide repeating labels

“

- [Voiceover] We're looking at a worksheet called restore labels hide labels, and those are the two features that we want to show in this movie. Imagine you receive this list, and your looking at it, and you realize that it's been set up in such a way, possibly for printing or just reviewing on the screen, these people here are in the ADC Department. We're not seeing the department name. It probably makes it a little bit easier to read, the screen's less crowded. We don't see Admin Training here, but all these people are in Admin Training. As we look up and down the list, we see this is true for the other departments as well. And maybe this was set up for printing purposes too. Quick print preview, control F2 will get us there fast, confirms that, and that does make it a bit easier to read. Now, there's a problem though, because what if we want to use this data, not only for printing, but for different reasons. We might wanna sort this by employee name. I'm gonna sort this list. Let's…

Contents