Die-hard Excel users hardly look at new ways, but in order to optimize working with filters and sorting, you can also try new ways. The usual way is via the menu bar or now via the menu ribbon in Excel 2007 or 2010.

 

The normal route is as follows:

But there is one via the context menu Sorting or filtering Possibly. faster. I have prepared an example to make it clearer.

A small table with the item and price.

 

To filter the table on an article, simply click on any article number in the example 123456 > right mousekey > Filter > Filter on the value of the selected cell

 

Then you get the following figure:

I want a table sort quickly if you click on any article> right mousekey > Sort by > Sort by size (ascending)

 

Then you get the following figure:

When sorting, the column with price was also sorted logically.

Have fun trying.

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.