Optionally, create the custom list: In a range of cells, enter the values that you want to sort by, in the order that you want them, from top to bottom. I have a huge data table that I'll need sorted automatically by changing anything in column A. alexholden, Oct 8, 2014 #1 Keebellah Hans Trusted Advisor Joined: Mar 27, 2008 Messages: 6,205 Hi Alex, Welcome to the forum Is there any relation between the values in each column? What I would like to be able to do is to make it so that if I sort the 1st column, it sorts the column data, while also rearranging the rows his comment is here
Top of Page Share Was this information helpful? No, create an account now. Pheb18 Sep 2015, 03:57 Hi Barry,My apology for incomplete data. To sort by value, do this: For text values, select A to Z or Z to A.
Click OK, and then copy the data. Check out Professional Excel Development today! In general, you can do the following: Create a summary report. We cannot do this for our data because Column A lists different features and we want it to stick in place.
Then select the row by which you want to sort. For date or time values, select Oldest to Newest or Newest to Oldest. Under Order, select On Left or On Right. How To Sort Columns In Excel Without Mixing Data Note: To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting.
Select a range of cells with two or more columns of data, or make sure that the active cell is in a table with two or more columns. I can sort them manually this way using the custom sort I enter. For more information, see Filter data in an Excel table or range, and Add, change, find, or clear conditional formats. Top of Page Sort one column in a range of cells without affecting the others Warning: Be careful when using this feature.
To add another column to sort by, click Add Level, and then repeat steps three through five. Excel Auto Sort When Data Changes Note: You cannot do the following procedure in a table. Reply santosh kumar says: February 15, 2015 at 6:57 am Thank you soo much for great help brother,, can i have your mail ID please,, Reply Bruce says: May 12, 2015 Detail data at lower levels is then hidden.
share|improve this answer edited Aug 1 '13 at 23:10 stderr 7,94121439 answered Aug 1 '13 at 22:56 Dappy 416 add a comment| up vote 0 down vote considering that , all http://superuser.com/questions/605304/in-excel-how-to-sort-a-column-and-keep-respective-values-in-other-columns In the example below, to group rows 2 through 5, which has a summary row 6, select rows 2 through 5. How To Sort A Column In Excel And Keep Rows Together Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. Excel Locking Rows Together When Sorting If rows or columns are still hidden, drag across the visible row or column headings on both sides of the hidden rows and columns, point to Hide & Unhide on the
Check the locale setting Sort orders vary by locale setting. this content Secondly, the Board basis column is sorted, so that all-inclusive (AL) hotels are at the top of the list. Under Order, select Custom List. Willy Vanhaelen23 Sep 2016, 13:15 @Mike S.It can be done but by adding records, it will be very unreliable.When you enter data in A, B, and C consecutively this will happen:1) Sort One Column To Match Another In Excel
Click on the "Sort By" drop-down menu to select a column by name. In the Sort Options dialog box, select Case sensitive. Read More Free Download NowRecommended Productivity ToolsOffice Tab: Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.Try nowKutools for Excel: 200 new features http://todayspec.com/in-excel/auto-update-the-date-in-excel.php i'd like to sort it from a to z, the trouble is there were columns with employee's information.
You can also ungroup sections of the outline without removing the entire outline. How To Sort Data In Excel Using Formula The only way that this can be done is by using a macro that is triggered whenever something new is entered in the worksheet. Mike S24 Sep 2016, 09:27 @ Willy Vanhaelen the list does not change it is an overtime sorting list with persons name and their seniority date that do not change then
You need to click the Reapply button on the Data tab, in the Sort & Filter group:Well, as you see sorting Excel data by custom list does not present any To reapply a sort after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply. Insert summary rows. Advanced Sorting In Excel What you discribe is in fact a conditional sorting and Excel doesn't provide that.You can solve it with a help column though.
Join over 733,556 other people just like you! On the Data tab, in the Outline group, click Group. View the most recent issue. check over here On the Data tab, in the Outline group, click the Outline Dialog Box Launcher.
share|improve this answer answered Jun 8 '13 at 13:03 zgall1 1015 This will sort data in ALL rows, not just the row filtered. –music2myear Jan 19 at 23:00 add Here I introduce a VBA macro to help you auto sort a specific column by value in Excel.Auto sort column by value with VBAEasily sort by frequency of occurrences in ExcelKutools share|improve this answer answered Jan 13 at 14:48 rajesh 1 add a comment| up vote -1 down vote I have just been through this myself. Column A is Length, Column B is Width, and Column C is Height.
On the Home tab, in the Editing group, click Sort & Filter, and then click one of the available sort commands.The Sort Warning dialog box appears. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion. Im using 2007 excel. To sort based on a custom list, select Custom List.
Since our sheet has headers, we leave the tick and click the Options button. Copyright ©2017 · 404TechSupport.com Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! Under Order, select how you want to sort. However, I still can't seem to get it to work when I put that code into sheet 1.Thanks!Mike Mike28 Aug 2015, 14:37 Thanks!
Willy Vanhaelen29 Sep 2015, 10:49 @maryanne,This macro will probably suit your needs.Private Sub Worksheet_Change(ByVal Target As Range)If Target.Column <> 1 Or Target.Columns.Count > 1 Then Exit SubDim tmp As Varianttmp =