Solved Expand range (1 Viewer)

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 19:10
Joined
Feb 19, 2002
Messages
33,677
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.
Range.JPG
 

Darrell

Registered User.
Local time
Today, 00:10
Joined
Feb 1, 2001
Messages
235
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

Enthusiastic Amateur
Local time
Today, 00:10
Joined
Sep 21, 2011
Messages
9,276
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

Super Moderator
Staff member
Local time
Yesterday, 19:10
Joined
Feb 19, 2002
Messages
33,677
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
 

Users who are viewing this thread

Top Bottom