| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print selected columns that are not adjacent in Excel
In sorting specified columns by hiding unwanted columns, Excel sorts as
requested but stops sorting about 20 lines before the end of the worksheet, leaving those 20 lines unsorted. How to get the entire worksheet sorted? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print selected columns that are not adjacent in Excel
Make sure you select the entire range to sort first. Then Data|Sort that range.
If you let excel guess at the range to sort, it may not guess what you want. Patlee wrote: In sorting specified columns by hiding unwanted columns, Excel sorts as requested but stops sorting about 20 lines before the end of the worksheet, leaving those 20 lines unsorted. How to get the entire worksheet sorted? Thanks. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print selected columns that are not adjacent in Excel
Thank you for responding. I tried again, making certain I highlighted the
entire column but same result. When it reaches a certain row it starts sorting again for several lines and then starts sorting again. "Dave Peterson" wrote: Make sure you select the entire range to sort first. Then Data|Sort that range. If you let excel guess at the range to sort, it may not guess what you want. Patlee wrote: In sorting specified columns by hiding unwanted columns, Excel sorts as requested but stops sorting about 20 lines before the end of the worksheet, leaving those 20 lines unsorted. How to get the entire worksheet sorted? Thanks. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel should show Comment box even if adjacent columns are hidden | Excel Discussion (Misc queries) | |||
| How do you print selected columns on one page? | Excel Discussion (Misc queries) | |||
| Forcing an Excel spreadsheet to print only selected groups of cel. | Excel Worksheet Functions | |||
| EXCEL - Cannot print borders in color(s) I have selected | Excel Discussion (Misc queries) | |||
| Deselect one of many non-adjacent rows selected | Excel Discussion (Misc queries) | |||
Linear Mode
