| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORTING AN EXCEL SPREADSHEET ROW BY ROW
I have 100 rows of numbers.
How do I select the 100 rows and make excel sort each row individually in ascending order from left to right? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SORTING AN EXCEL SPREADSHEET ROW BY ROW
Not possible, you can only sort 3 rows at a time but if you want to sort
individually you need to sort them row by row one at a time -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Patricia" wrote in message ... I have 100 rows of numbers. How do I select the 100 rows and make excel sort each row individually in ascending order from left to right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing an Excel spreadsheet from the web. | Excel Discussion (Misc queries) | |||
| Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
| Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
| Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
