Learn Excel At Home - Beginners To Expert: Most suitable book for self learning. Be an Excel Expert in One Week! by Vivek Kaushik

Author:Vivek Kaushik
Language: eng
Format: azw3
Publisher: UNKNOWN
Published: 2017-08-26T07:00:00+00:00

Sorting Data

Custom sorting

To sort by cell color, font color, or cell icon:

1. From the Data tab, click the Sort command to open the Sort dialog box.

2. Identify the column you want to Sort by by clicking the drop-down arrow in the Column field.

3. Choose whether you want to sort by Cell Color, Font Color, or Cell Icon in the Sort On field. In this example, we'll sort by Font Color.

4. In the Order field, click the drop-down arrow to choose a color, then decide whether you want it ordered On Top or On Bottom.

5. Click OK. The data is now sorted by attribute rather than text.

By : Vivek Kaushik 135

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.