| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only the first 5 columns of a 10 column excel spreadsheet sort
How do I get the whole spread sheet to sort? There is a blue lox for the
first 5 columns that limits the range of the sort. How do I remove it? Using Office 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only the first 5 columns of a 10 column excel spreadsheet sort
Maybe if you remove the Data|list
Select a cell in that blue box. Data|list|convert to range jrw562 wrote: How do I get the whole spread sheet to sort? There is a blue lox for the first 5 columns that limits the range of the sort. How do I remove it? Using Office 2003. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an Excel Spreadsheet automatically sort new data? | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Can you sort a column in Excel that's different by colored font? | Excel Worksheet Functions | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
| How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
Linear Mode
