How to print selected columns that are not adjacent in Excel

P

Patlee

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.
 
D

Dave Peterson

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.
 
P

Patlee

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting columns in Excel 1
How to print selected columns that are not adjacent in Excel 0
print selected cells in Excel 3
How do I delete extraneous EXCEL columns? 4
How do I print only a selected area in Excel 2007 1
how many columns are included in a standard sort in Excel? 1
How to print cell # while printing in excel 0
How do I get excel to display the number of columns selected? 1

Top