EXCEL help (sorting)

dvdsteve2000 · 11-03-09, 07:59 PM

OK, so I am copying & pasting into excel. Let's say I'm copying from a page that has the following info:

Release date (column A)
Country (column B)
Video Game Name (column C)
Sales (column D)
Rating (Column E)
Price (column F)

I copy & paste the info into Excel, but if I try to sort by video game name (column C), it only moves that column, which means the rest of the info isn't aligned correctly with the game since it only sorted column C. How do I go about getting everything to sort with column C, but use column C as the "A-Z" sort starting point?

Thanks,

~S2K

dick_grayson · 11-03-09, 08:08 PM

try paste-special-values instead of regular paste. or you can select the whole sheet and copy and paste it over itself. it'll then sort beyond that one column

dvdsteve2000 · 11-03-09, 08:30 PM

OK, I tried using paste special...there were 3 options, text & another crammed everything together without columns, so that's no good, and HTML didn't work when I sorted.

I don't understand what you mean by copy/paste the whole sheet over itself to get it to sort beyond that column. Sorry, I'm not very good with excel.

belboz · 11-03-09, 08:50 PM

You can try it the old fashioned way where you select the whole table and then tell it to sort. It should prompt you with a dialog where you then specify which column to sort by and whether you want ascending or descending sort.

dvdsteve2000 · 11-03-09, 09:07 PM

Quote:

Originally Posted by belboz

You can try it the old fashioned way where you select the whole table and then tell it to sort. It should prompt you with a dialog where you then specify which column to sort by and whether you want ascending or descending sort.

You are a GOD!!! THANK YOU!!!!!!!!!

11-03-09, 07:59 PM	#1
dvdsteve2000 DVD Talk Limited Edition Join Date: Feb 2000 Location: Home of the 2009 Stanley Cup & Vince Lombardi trophy!!! Posts: 5,742	EXCEL help (sorting) OK, so I am copying & pasting into excel. Let's say I'm copying from a page that has the following info: Release date (column A) Country (column B) Video Game Name (column C) Sales (column D) Rating (Column E) Price (column F) I copy & paste the info into Excel, but if I try to sort by video game name (column C), it only moves that column, which means the rest of the info isn't aligned correctly with the game since it only sorted column C. How do I go about getting everything to sort with column C, but use column C as the "A-Z" sort starting point? Thanks, ~S2K __________________ XBOX 360 GAMERTAG: Snippy DePini: My old tag, (R.I.P.), SOFA KIN WHAT: Ex-Interim Tag: WiiTards Suck ACHIEVEMENT POINTS: 22,240/74,270 (29.94%) 360 BLOG

11-03-09, 08:08 PM	#2
dick_grayson DVD Talk Legend Join Date: Mar 2003 Location: Lyon Estates Posts: 10,487	Re: EXCEL help (sorting) try paste-special-values instead of regular paste. or you can select the whole sheet and copy and paste it over itself. it'll then sort beyond that one column

11-03-09, 08:30 PM	#3
dvdsteve2000 DVD Talk Limited Edition Join Date: Feb 2000 Location: Home of the 2009 Stanley Cup & Vince Lombardi trophy!!! Posts: 5,742	Re: EXCEL help (sorting) OK, I tried using paste special...there were 3 options, text & another crammed everything together without columns, so that's no good, and HTML didn't work when I sorted. I don't understand what you mean by copy/paste the whole sheet over itself to get it to sort beyond that column. Sorry, I'm not very good with excel. __________________ XBOX 360 GAMERTAG: Snippy DePini: My old tag, (R.I.P.), SOFA KIN WHAT: Ex-Interim Tag: WiiTards Suck ACHIEVEMENT POINTS: 22,240/74,270 (29.94%) 360 BLOG

11-03-09, 08:50 PM	#4
belboz DVD Talk Gold Edition Join Date: Feb 1999 Location: HB, CA Posts: 2,414	Re: EXCEL help (sorting) You can try it the old fashioned way where you select the whole table and then tell it to sort. It should prompt you with a dialog where you then specify which column to sort by and whether you want ascending or descending sort. __________________ "History is the fiction we invent to persuade ourselves that events are knowable and that life has order and direction. That's why events are always reinterpreted when values change. We need new versions of history to allow for our current prejudices."