0
No, you can sort multiple columns or rows if you hightlight a range, but all columns or rows will need to be sorted with the same criteria (e.g. lowest to highest).
You can sort an entire row by clicking on the row number at the left of the screen, then sort, as desired. You also can do the same for columns by clicking on the column letter at the top of the screen.
Wiki User
∙ 14y ago
Wiki User
∙ 9y agoYou cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
You cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
Wiki User
∙ 9y agoYou cannot individually sort more than two columns, like taking two separate columns and putting each into numerical or alphabetical order. You can either sort a single column or a table as one unit. You can have a primary sort and a secondary sort within one table on separate columns. A classic example is sorting by surname and within each surname by name, like the way a phone book is done.
Wiki User
∙ 9y agoYes it can be.
Add your answer:
Earn +20 pts
What excel 2007 feature lets you easily work with your data to filter and sort data using column list arrows?
table style
What happens if you sorted a column by choosing the column heading in Excel?
It would use the data in the column as the basis for the sorting and sort the rest of the data.
How do I sort formula based values in Excel?
Copy the formulas and in the column next to them, use the Paste Special option and choose values. It will put the actual values into the cells. You can then sort your data based on the column of values.
How do you alphabetize Names and corresponding addresses when they are in separate columns in Excel?
Ideally have the names in the first column of your data. Then select the column that has the names in it and the other columns. The active cell should be in the first column. Then go up to "Data" on the toolbar or the Sort and Filter options. You can select to sort alphabetically. If the Names are not in the first column you can use the Advanced sort option and choose it as the column you want to sort on when all of the columns of data are selected.
How do you sort columns in excel when some of the cells are blank?
Select the columns as normal and use the sort icon, or command on the Data menu to sort them. If you have more than one column selected, the column in which the active cell is will be used to sort. If you want to sort on a number of combinations, like surname and then firstname, that can be done through the data menu. Blank cells will be sorted to the end and the rest of the data will be sorted as usual.
When sorting a Excel worksheet can you sort multiple columns within the same sort?
You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.
Is it true that data can only be sorted by a single column (In Excel)?
If you only have a small amount of data, then it could be stored in a single column if appropriate.
What are the steps for sorting data using multiple fields?
Choose: Select -> Sort & Filter --> Custom Sort Choose the columns that you want to determine the sort, starting with the main column, and adding any others as appropriate. So you might sort first on the Surname column and then on the firstname column. For each column, choose the order you want to sort. Then click OK to apply the sort.
What is the benefit of using the Sort option?
There are many benefits of using the sort option in Excel. Some benefits are allowing you to sort by number, date, color, letter, columns, or text. This benefits the user because it allows the user to bring data up more easily.
How do you sort a few columns based on one column's values from low to high?
What you need to do is select all the data. Normally when doing this, the first column of the data you selected acts as the key to sorting it. So what you need to do next is to go to a Custom Sort and select the column to base your sort on. Then you can do it on a different column. That will work. When values change in Excel it does not automatically sort them again like in a database, so you will need to redo the sort occasionally. You could set a macro up to do that for you.
How do you sort column in an Excel document from 1 to 1000 if the numbers are currently 1000 to 1?
Select data in a column to be sorted (including title row). Go to sort and filter (this will be in different places depending on version of excel), then custom sort, then select A-Z.Any other time you can use this to reverse from low to high (Z-A) or low to high (A-Z). It may also appear under sort -descending or ascending. This does the same thing.
How do you sort data in Microsoft Excel if the data is an address with numbers in front but want to sort by the street name?
I would use the left and right functions to split up the address into 2 separate columns and then sort on column 2
