Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

EXCEL help (sorting)

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

EXCEL help (sorting)

Old 11-03-09, 07:59 PM
  #1  
DVD Talk Limited Edition
Thread Starter
 
dvdsteve2000's Avatar
 
Join Date: Feb 2000
Location: Home of the 2009 Stanley Cup & Vince Lombardi trophy!!!
Posts: 6,117
Likes: 0
Received 0 Likes on 0 Posts
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
Old 11-03-09, 08:08 PM
  #2  
DVD Talk Legend
 
Join Date: Mar 2003
Location: Lyon Estates
Posts: 10,795
Likes: 0
Received 0 Likes on 0 Posts
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
Old 11-03-09, 08:30 PM
  #3  
DVD Talk Limited Edition
Thread Starter
 
dvdsteve2000's Avatar
 
Join Date: Feb 2000
Location: Home of the 2009 Stanley Cup & Vince Lombardi trophy!!!
Posts: 6,117
Likes: 0
Received 0 Likes on 0 Posts
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.
Old 11-03-09, 08:50 PM
  #4  
DVD Talk Gold Edition
 
Join Date: Feb 1999
Location: HB, CA
Posts: 2,601
Likes: 0
Received 0 Likes on 0 Posts
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.
Old 11-03-09, 09:07 PM
  #5  
DVD Talk Limited Edition
Thread Starter
 
dvdsteve2000's Avatar
 
Join Date: Feb 2000
Location: Home of the 2009 Stanley Cup & Vince Lombardi trophy!!!
Posts: 6,117
Likes: 0
Received 0 Likes on 0 Posts
Re: EXCEL help (sorting)

Originally Posted by belboz View Post
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!!!!!!!!!

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.