![]() |
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