ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I sort several columns in excel (https://www.excelbanter.com/excel-worksheet-functions/39057-how-do-i-sort-several-columns-excel.html)

race510

how do I sort several columns in excel
 
I have entered data into several excel columns. Company is the first column
header, additional information in other columns is product name, quantity and
price. Now that I have finished inventory I would like to sort the data by
the first column (company name) but obviously have the other company data
sort appropriately with the correct respective company. I don't remember how
to do it.

.

race510 wrote:
Now that I have finished inventory I would like to sort the data by
the first column (company name) but obviously have the other company data
sort appropriately with the correct respective company. I don't remember how
to do it.


Select all the cells you want sorted (entire columns, rows or even the
entire sheet can be selected). Then Data-Sort. You'll get a dialogue
box which will allow you to specify the sort order & whether there is a
header row or not in your data range.



All times are GMT +1. The time now is 11:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com