Excel 2010 sort issue data in columns prior to sort column change

  csqwared 19:49 17 Jul 2014


Tried to replicate this in my Excel 2010 without success. Copied cells Sheet1/A1:A12 to Sheet2/C1:C12 with data in preceding columns A & B. On selecting 'Sort' for C1:C12 I get a window informing me there is data next to my selection and since it is not selected will not be sorted. There are then two options: Expand selection or Continue with current selection. Selecting second option sorts data normally.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei Mate 20 Pro review: In-depth hands-on

Adobe unveils dream prototypes of new features and apps for Creative Cloud

iPhone XR release date, price & specs

Comment utiliser la fonction SI sur Excel ?