Data Shorting By Text
Usage of Data Sorting –
Data sort by Value Content
In the Excel Sheet we can arrange Data by Different Order. Column Text List short by A to Z Alphabetical order Or reverse. Numerical column Data short by Smallest to Largest or Largest to Smallest. Date can arrange by Oldest to newest or Newest to oldest. Using this function we can Organize large Data as per our Requirement by only one click.
How to use Shorting Option –
Sort A to Z –
Select Data.
Home >> Sort & Filter >> Sort A to Z
Short Cut – Alt >> H >> S >> S
The Sort Function is useful for arranging the names or words in a column as alphabetical order or vice versa.
Names appears in the column C in the picture below. Select to sort it. In the home tab, select the sort & Filter option. Click Sort A to Z option from the Drop down list.
A new window will open sort waning. There are 2 option.
1.Expand the Selection
2.Continue with the current selection.
Select the 1st Option Expand Selection option to sort the information in the other column attached to the name. Then click Sort.
All information Related to the name is sorted.
COUNT Excel Data using COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
Continue with current Selection –
If you choose 2nd option Continue with current selection, your only selected data will be arranged according to the order. Remaining Data will not be changed.
Data Sort Z to A –
Select Data.
Home >> Sort & Filter >> Sort Z to A
Short Cut – Alt >> H >> S >> O
Use Sort Z to A Option to Arrange reverse alphabetical.
All information Related to the name is sorted by Z to A.
Get Data back to its Original Position –
Select Serial Number’s Data.
Home >> Sort & Filter >> Sort Smallest to Largest
Short Cut – Alt >> H >> S >> S
Use Sort Smallest to largest option to Arrange ascending order.
(If the data of the number is selected, excel will automatically show the tab- sort smallest to largest, instead of – sort A to Z)
Shorten the Serial Number to smallest to largest to return the arrange data to its original position.
