Xu Hướng 5/2022 # 3 Ways To Sort By Color In Excel # Top View

Xem 25,443

Bạn đang xem bài viết 3 Ways To Sort By Color In Excel được cập nhật mới nhất ngày 17/05/2022 trên website Hoisinhvienqnam.edu.vn. Hy vọng những thông tin mà chúng tôi đã chia sẻ là hữu ích với bạn. Nếu nội dung hay, ý nghĩa bạn hãy chia sẻ với bạn bè của mình và luôn theo dõi, ủng hộ chúng tôi để cập nhật những thông tin mới nhất. Cho đến thời điểm hiện tại, bài viết này đã đạt được 25,443 lượt xem.

--- Bài mới hơn ---

  • How To Allow Sorting And Filter Locked Cells In Protected Sheets?
  • Hướng Dẫn Sử Hàm Chức Năng Atan Trong Excel.
  • Calculating Coefficient Of Variation In Excel
  • Hướng Dẫn Sử Dụng Hàm Ln Trong Excel
  • Hocthue.net: Các Hàm Thống Kê Trong Excel Phải Biết Và Có Ví Dụ
  • There are several ways to sort data in Microsoft Excel. Learn how to use conditional sorting in Excel to sort by font color, cell background color, or icon color.

    Instructions in this article apply to Excel for Microsoft Office 365, Excel 2022, Excel 2022, and Excel 2013 for Windows and Mac.

    Select a Range to Be Sorted in Excel

    Before data can be sorted, Excel needs to know the exact range to sort. Excel can automatically include related data in a range so long as there are no blank rows or columns within the selected area. Blank rows and columns between areas of related data are okay. Excel then determines if the data area has field names and excludes those rows from the records to be sorted.

    Allowing Excel to select the range to be sorted is fine for small amounts of data. However, for large areas of data, the easiest way to ensure that the correct range is selected is to highlight it before sorting.

    If the same range is to be sorted repeatedly, the best approach is to give the range a name. If a name is defined for the range to be sorted, type the name in the Name Box, or select it from the associated drop-down list. This way, Excel automatically highlights the correct range of data in the worksheet.

    Any sorting requires the use of sort order. When sorting by values, there are two possible sort orders: ascending and descending. However, when sorting by colors, no such order exists, so you must manually define the color sort order.

    How to Sort by Cell Background Color in Excel

    In the example below, the records of students age 20 and younger are highlighted in red. To sort the data by cell background color so that the red entries appear on top:

    1. Highlight the range of cells to be sorted (cells A2 to D11 in the example).

    2. Select the Sort on drop-down arrow and choose ​Cell Color.

      Clear the My data has headers check box so that the first row doesn’t get cut off.

    3. Select the Order drop-down arrow and choose Red.

      When Excel finds different cell background colors in the selected data, it adds those colors to the Order drop-down list in the dialog box.

    4. Choose On Top from the drop-down list next to the sort order box so that the red cells will be at the top of the list, then select OK.

    5. The four records with red backgrounds are grouped together at the top of the data range.

      When working with calculations, you can make negative numbers in Excel appear red by default to help those numbers stand out more.

    How to Sort by Font Color in Excel

    In the example below, the records of students enrolled in nursing programs appear in red, and those enrolled in science programs are blue. To sort the data by font color:

    1. Highlight the range of cells to be sorted (cells A2 to D11 in the example).

    2. Select the Sort on drop-down arrow and choose ​Font Color.

      Clear the My data has headers check box so that the first row doesn’t get cut off.

    3. Select the Order drop-down arrow, then choose Red.

      When Excel finds different font colors in the selected data, it adds those colors to the Order drop-down list in the dialog box.

    4. Choose On Top from the drop-down list next to the sort order box so that the red entries will be at the top of the list.

    5. Select Add to add a second sort level.

    6. Use the same settings as the first sort level, but this time select the Order drop-down arrow and choose Blue.

    7. Select OK to sort the data and close the dialog box.

    8. The two records with the red font color are grouped together at the top of the data range, followed by the two blue records.

    How to Sort by Icon in Excel

    Icon sets offer an alternative to regular conditional formatting options that focus on the font and cell formatting changes. The example below contains dates and temperatures that have been conditionally formatted with the stoplight icon set based on the daily maximum temperatures.

    Follow these steps to sort the data so that records displaying the green icons are grouped first, followed by the yellow icons, and then the red icons:

    1. Highlight the range of cells to be sorted (cells A2 to B31 in the example).

    2. Select the Column drop-down arrow, then choose the column containing the conditional icons (Temperature in the example).

      Due to the way conditional formatting with icons works, you can leave the My data has headers check box selected.

    3. Select the Sort on drop-down arrow, then choose Conditional Formatting Icon.

    4. Select the Order drop-down arrow, then choose Green.

    5. Choose On Top from the drop-down list next to the sort order box so that the green icon entries will be at the top of the list.

    6. Select Add to add a second sort level.

    7. Use the same settings as the first sort level, but this time select the Order drop-down arrow and choose Yellow.

    8. Select Add to add a third sort level, then use the same settings as the first two levels, but this time select the Order drop-down arrow and choose Red.

    9. Select OK to sort the data and close the dialog box.

    10. The records with the green icon are grouped together at the top of the data range, followed by the records with the yellow icon, and then those with a red icon.

    --- Bài cũ hơn ---

  • How To Sort Data By Color In Excel?
  • How To Filter And Sort Cells By Color In Excel 2022, 2013 And 2010
  • How To Alphabetize In Excel: Sort Alphabetically Columns And Rows
  • How To Use The Excel Sort Function
  • How To Sort In Excel
  • Cập nhật thông tin chi tiết về 3 Ways To Sort By Color In Excel trên website Hoisinhvienqnam.edu.vn. Hy vọng nội dung bài viết sẽ đáp ứng được nhu cầu của bạn, chúng tôi sẽ thường xuyên cập nhật mới nội dung để bạn nhận được thông tin nhanh chóng và chính xác nhất. Chúc bạn một ngày tốt lành!

  • Web hay
  • Links hay
  • Guest-posts
  • Push
  • Chủ đề top 10
  • Chủ đề top 20
  • Chủ đề top 30
  • Chủ đề top 40
  • Chủ đề top 50
  • Chủ đề top 60
  • Chủ đề top 70
  • Chủ đề top 80
  • Chủ đề top 90
  • Chủ đề top 100
  • Bài viết top 10
  • Bài viết top 20
  • Bài viết top 30
  • Bài viết top 40
  • Bài viết top 50
  • Bài viết top 60
  • Bài viết top 70
  • Bài viết top 80
  • Bài viết top 90
  • Bài viết top 100
  • Chủ đề top 10
  • Chủ đề top 20
  • Chủ đề top 30
  • Chủ đề top 40
  • Chủ đề top 50
  • Chủ đề top 60
  • Chủ đề top 70
  • Chủ đề top 80
  • Chủ đề top 90
  • Chủ đề top 100
  • Bài viết top 10
  • Bài viết top 20
  • Bài viết top 30
  • Bài viết top 40
  • Bài viết top 50
  • Bài viết top 60
  • Bài viết top 70
  • Bài viết top 80
  • Bài viết top 90
  • Bài viết top 100