In this case, these assumptions were all correct, so everything worked out well.
Columns A and B are elements of a single dataset, so rows should be kept together when a column is sorted. Row 1 is a header row and should not be sorted with the list of names. These two “quick-sort” methods work well on this dataset because Excel made the following assumptions: To remove the filter dropdown arrows, click on the Filter icon again.īoth the Sort and Filter options are also accessible from the Home tab by using a dropdown menu and selecting their respective icons. If the list had been sorted from Z to A, the arrow would have been shown in the opposite direction. The dataset is sorted with the same results as the previous method and shows a tiny arrow next to the Column A dropdown arrow. Step 3 - Click the dropdown arrow list on the Last Name header, and select the Sort A to Z command from the context menu. Step 1 - Click on a cell in the column you want to sort by. Of course, you can also see that there is an option to sort in descending order by using the “Z-A” sort icon instead.Īn alternative to the above method is to use the Filter command, also on the Data tab. The last names will be sorted alphabetically in ascending order by the column of your active cell. Step 2 - Go to the Data tab and click this icon: Notice that A4 is our active cell in the above example. The absolute quickest way to alphabetize columns in Excel is to use the “A to Z” icon on the Data tab. Using the data set below as a sample, we would probably want to alphabetize by last name using Column A. Alphabetize columns in Excel Method 1 - Using the A-Z icon Since Excel is all about handling and organizing data, it’s no surprise that this is one of the built-in tasks it handles really well. This is because it uses a standard system (the alphabet) to arrange items, so there is an accepted location for each item on the list. So, now by doing this, we’ve a clear understanding about the Align-buttons when and where to use them appropriately.Placing items in alphabetical order is one of the most common ways of organizing data. Notably, if we did all the steps correctly the position of the character “A” shifted to Six locations within a cell. In the same way, select the Align Left, Center-Align and the Align Right for the all the Bottom Cells respectively. Likewise, then click the Right Top Cell and select the Bottom Align. Next, select the Second Middle Top Cell and click the Middle Align. And, then click the First Left Top Cell and select the Top Align. Type the Alphabet “A” in all of the Six cells starting from the Left Top Cell to the Right Bottom Cell. So, now we have six cells which have Dimensions 50 X 15 of each one of them. And, then select three Columns and set the the Column Width to 15 (110 Pixels). To understand the Align buttons, firstly select three Rows and set the Row Height to approx 50 (66 Pixels). 
Using Align buttons of Alignment group Excel – continued Secondly, the Numeric (Numbers) when put in a cell, by default shift to the right side border of the cell. Also, the Special Characters shift left side of the cell border. Further, is some information that shall be remembered by the users.įirst of all, the Text (Alphabets) when typed in a cell, by default shift to the left side cell border. In addition, are the Align Left, Center-Align and the Align Right buttons etc. So, the Six Align buttons are the Top Align, Middle Align and the Bottom Align etc.
The buttons other than these Six are the Orientation, Decrease Indent, Increase Indent and the Merge & Center. In total, this group has Eleven buttons including the Six Align buttons. So, the Alignment group of the Home tab has Six Align buttons. Now, a furthermore explanation about the Align buttons shall be given through this post. See Previous Post: Border buttons description Font group Home tab MS Excel 2016 Align buttons Alignment group Home tab Excel
0 kommentar(er)
