Page 123 - Ms Excel Note and Workbook
P. 123
MICROSOFT EXCEL NOTE AND WORKBOOK
11 WORKING WITH DATA
Types of Sorting
When sorting data, it's important to first decide if you want the sort to apply to the entire
worksheet or just a cell range.
• Sort sheet organizes all of the data in your worksheet by one column. Related
information across each row is kept together when the sort is applied. In the example
below, the Contact Name column (column A) has been sorted to display the names in
alphabetical order.
• Sort range sorts the data in a range of cells, which can be helpful when working with a
sheet that contains several tables. Sorting a range will not affect other content on the
worksheet.
TIP
Sorting a range will not
affect other content on the
worksheet.
114 | P a g e
