From the course: Excel 2010 Essential Training

Unlock the full course today

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

Using tables to sort and filter data

Using tables to sort and filter data - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Using tables to sort and filter data

Excel has a feature called tables, which adds some nice features to sorting and filtering. And if you watched the movie on basic sorting and multiple fields sorting, I think you'll like some of the features that tables add. Well, to convert this area to a table, we go to the Insert tab. Now, this is kind of a misnomer, because we're going to click Table under the Insert tab, but we're not actually inserting anything. We're simply taking this whole range of data and converting it to a table. So click anywhere in here. It doesn't matter which cell you select. Click Table and you see Excel correctly guesses what area we have for our table. And you want to make sure this box is selected because we do have headers there. And click OK. Now, scroll up a bit and you see Excel puts in these little down arrows so we can sort and filter. As long as you have one of these cells selected, you'll be in the Table Tools section in the Design tab. So let's do some sorting and filtering before anything.…

Contents