| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Sort
I have two rows of data that contain text & numbers. I want to sort the data
but the text fields must remain at the top, is this possible? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Sort
After you choose Data | Sort and the window comes up asking about what to
sort, Click the [Options] button and you'll find a Left To Right option there so that the sort is done across the sheet instead of up/down the page. Then when you close that window you'll be able to choose which rows to sort by instead of which columns. "The Toasterman" wrote: I have two rows of data that contain text & numbers. I want to sort the data but the text fields must remain at the top, is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort source workbook data, maintain formulas in destination workb. | Excel Worksheet Functions | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
