how many columns are included in a standard sort in Excel?

H

HawaiiJen

I have an Excel worksheet that is 34 columns wide. When I sorted the rows
(without highlighting it), only the first 24 columns got included in the
sort. I save the data before realizing this happened so now my information
is thoroughly messed up.

Does anyone know why Excel didn't include all 34 columns? Thank you!
 
N

Nick Hodge

Jen

Excel takes a stab at the usedrange and this is normally the contiguous
block of data emanating from the activecell. It is not uncommon for Excel to
get this wrong, so selection is always the best course to avoid doubt. I
suspect the data you have was seen as having gaps basically

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk

UK Excel User Conference In Cambridge
November 28th - December 1st 2007
Register Now @ http://www.exceluserconference.com/UKEUC.html
 

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

How to sort entire spreadsheet by one column sort 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Excel Column Width in XLSX 0
How to sort when I have multiple header rows (not included in sor. 1
Default column in Excel sort - Office 2007 7
Sorting issue with frozen panes 11
Columns not sorting properly. 2
Macro that sorts data with blanks at the bottom 1

Top