Solved Expand range

[Pat Hartman]

I downloaded a csv file from the web. I did some sorting on it. Then I added a calculated column at the right named "month" so I could sum by month but I can't figure out how to get Excel to "see" the new column. It doesn't show in the sort dialog and as you can see by the picture, it isn't part of the range so not seeing it in the sort by dropdown makes sense in that context. I expanded the page format to include Month but that didn't help. The same issue happens with the subtotal dialog.

 

[Darrell]

I think the fact that there is an empty column in between your data causes Excel to just ignore the other column. You would need to manually select the columns and then click sort

 

[Gasman]

Pat,
You have My Data Has Headers set, but are not highlighting them.?
If you select the whole sheet, you will get your month, plus a Column1 which is the empty column between month and the rest of the data.?

HTH

 

[Pat Hartman]

I didn't do the highlighting. When you press the sort button, Excel highlights the set.

I didn't notice the extra column. Removing it fixed the problem with the dialogs.

Thanks