Solved

Microsoft Office Excel Data Sort

Posted on 2013-06-28
2
429 Views
Last Modified: 2013-06-28
Is there any way to have data auto-sort when I paste it into an Excel document? Rather than having to go to Data > Sort..
0
Comment
Question by:submarinerssbn731
2 Comments
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 39285117
Not that I know. Only other way is doing it through Macros.

That is, having a macro, once you paste, you can click a shortcut to initiate the 'sorting' macro.
0
 

Author Comment

by:submarinerssbn731
ID: 39285165
Oh, ok. Well thanks for the help anyways.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question