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

G

Guest

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

Sort Contiguous Columns - Danger 3
prevent sorting from moving rows/colums out of order 1
Are Hidden Rows/ Columns Included in a Sort? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How many columns in Excel? 3
how to sort in a protected worksheet. 17
How do I sort A1 THROUGH F26 alphabetically? 6
Sort Problem 1

Top