Then go to the Ribbons Data tab, find the Sort and Filter group, and click Sort.

The first time you click this button, the sort is lowest to highest or alphabetical.

Click the button again to sort highest to lowest or reverse alphabetically.

If you do, the sort will be applied only to the contents of the column, not the entire table or data range.

Filter is turned on by default when you make a table, and you can see these buttons in the header row of a table.

When you click the Filter button in a column header, the Filter dialog displays.

If you havent applied colors or conditional formatting, this pop-up menu is inactive.

Then, in the pop-up menu to the right, you can select a record from the column that matches the set of conditions.

Excel 2011 More Button On Chart Style Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Excel 2011 For Mac More Button On Chart Style