Look Who it Was Random video

Excel - Master Excel Data Analysis with Cell Styles | Microsoft Excel Tutorial - Episode 1053

339 views · Published 8 July 2009 · 1:58 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel Data Analysis with Cell Styles.

Welcome back to the MrExcel netcast! In this video, we will be discussing how to find cell styles in Excel. As we all know, working with large amounts of data can be overwhelming. That's why it's important to know how to efficiently analyze and organize your data. And what better way to do that than with the help of cell styles?

In this tutorial, I, Bill Jelen, will show you how to use cell styles to easily identify and select specific types of cells in your spreadsheet. We will start off by using a pivot table to analyze our data. Then, I will present you with a problem and challenge you to solve it. Are you up for it?

In a previous video, I used the "go to special" function to find all the input cells that were numeric. However, I also mentioned that using cell styles to mark these cells would be a great alternative. So, let's say you have already been using cell styles to label your input cells. Not only does this make it easier to identify them, but it also gives us another way to select them.

Instead of using "go to special" this time, we will use the "find" function. By opening up the options and selecting "format", we can choose a specific cell style and find all the cells that match it. This is a great way to quickly select and manipulate a certain class of cells. And as always, I will provide you with some helpful shortcuts along the way.

I want to thank you for watching this tutorial and I hope you found it useful. Don't forget to check out our other netcasts on the MrExcel channel for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Challenge: Finding numeric input cells
(00:15) Using cell styles to mark input cells
(00:37) Using find to select cells with a specific format
(01:18) Advantages of using cell styles
(01:36) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Advantages of using cell styles
Analyzing massive amount of data
Finding all input cells with find function
Finding numeric input cells
Formatting cells as input cells
MrExcel netcast
Pivot table problem solving
Selecting a class of cells with find function
Selecting all input cells
Using cell styles to mark input cells
Using go to special
YouTube video search terms: 
Zeroing out input cells with control+Enter

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152510/



If Jerry from podcast 1052 had been using cell styles to mark his input cells, he could have used advanced options in the Find dialog to clear all of the input cells. Episode 1053 shows you how.

More from this channel