Sort excel and be able to revert to previous order after editsHow to preserve sort order in Excel...
Draw bounding region by list of points
Why did the Cray-1 have 8 parity bits per word?
Why are special aircraft used for the carriers in the United States Navy?
Is there a math equivalent to the conditional ternary operator?
Why would the IRS ask for birth certificates or even audit a small tax return?
Should we avoid writing fiction about historical events without extensive research?
Has Wakanda ever accepted refugees?
Is divide-by-zero a security vulnerability?
Is there a full canon version of Tyrion's jackass/honeycomb joke?
What is better: yes / no radio, or simple checkbox?
For the Kanji 校 is the fifth stroke connected to the sixth stroke?
Must 40/100G uplink ports on a 10G switch be connected to another switch?
Rationale to prefer local variables over instance variables?
When do _WA_Sys_ statistics Get Updated?
Wardrobe above a wall with fuse boxes
PTIJ: Aharon, King of Egypt
What is the difference between 主菜 and 主食?
If nine coins are tossed, what is the probability that the number of heads is even?
Did Amazon pay $0 in taxes last year?
School performs periodic password audits. Is my password compromised?
What is the minimum amount of skill points per HD?
How to mitigate "bandwagon attacking" from players?
How do you say “my friend is throwing a party, do you wanna come?” in german
Can a space-faring robot still function over a billion years?
Sort excel and be able to revert to previous order after edits
How to preserve sort order in Excel Pivot-table?Excel-matching row order in two spreadsheetsHow to sort only part of multiple columns in ExcelGrouping and sorting rows in Excel based on single columnSort Excel Row Based on Values in Another RowExcel 2013: Convert row into two rows and edits both rowsExcel: sort according to example rowExcel 2013 Pivot Table Auto Sort OrderExcel macro to sort two columns side by sideExcel formula to sort data based on unique individuals?
I manage a spreedsheet that has about 30 columns and around 140 rows. It is a manning roster, and there is a set order that it needs to be in by office. Sometimes I need to sort by date or some other factor. When I sort it and make edits, I then have to cut and paste the rows back together in the original order.
Is there a way to sort, make edits, and then put the rows back in the original order without cutting and pasting?
One work around would be to have a hidden column that numbers each row, and use that to put them back in order, but I am trying to find a way to do this without having hidden rows.
Thank you!
microsoft-excel sorting microsoft
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I manage a spreedsheet that has about 30 columns and around 140 rows. It is a manning roster, and there is a set order that it needs to be in by office. Sometimes I need to sort by date or some other factor. When I sort it and make edits, I then have to cut and paste the rows back together in the original order.
Is there a way to sort, make edits, and then put the rows back in the original order without cutting and pasting?
One work around would be to have a hidden column that numbers each row, and use that to put them back in order, but I am trying to find a way to do this without having hidden rows.
Thank you!
microsoft-excel sorting microsoft
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago
add a comment |
I manage a spreedsheet that has about 30 columns and around 140 rows. It is a manning roster, and there is a set order that it needs to be in by office. Sometimes I need to sort by date or some other factor. When I sort it and make edits, I then have to cut and paste the rows back together in the original order.
Is there a way to sort, make edits, and then put the rows back in the original order without cutting and pasting?
One work around would be to have a hidden column that numbers each row, and use that to put them back in order, but I am trying to find a way to do this without having hidden rows.
Thank you!
microsoft-excel sorting microsoft
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I manage a spreedsheet that has about 30 columns and around 140 rows. It is a manning roster, and there is a set order that it needs to be in by office. Sometimes I need to sort by date or some other factor. When I sort it and make edits, I then have to cut and paste the rows back together in the original order.
Is there a way to sort, make edits, and then put the rows back in the original order without cutting and pasting?
One work around would be to have a hidden column that numbers each row, and use that to put them back in order, but I am trying to find a way to do this without having hidden rows.
Thank you!
microsoft-excel sorting microsoft
microsoft-excel sorting microsoft
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Allyson ParkerAllyson Parker
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Allyson ParkerAllyson Parker
61
asked yesterday
Allyson ParkerAllyson Parker
61
61
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Allyson Parker is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago
add a comment |
1
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago
1
1
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Allyson Parker is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1411478%2fsort-excel-and-be-able-to-revert-to-previous-order-after-edits%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Allyson Parker is a new contributor. Be nice, and check out our Code of Conduct.
Allyson Parker is a new contributor. Be nice, and check out our Code of Conduct.
Allyson Parker is a new contributor. Be nice, and check out our Code of Conduct.
Allyson Parker is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1411478%2fsort-excel-and-be-able-to-revert-to-previous-order-after-edits%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Assuming there's no identifiable logic behind 'set order that it needs to be in by office'... 'a hidden column that numbers each row' is how this would be done. Sorry. Another workflow-based alternative would be to see if you could use a FILTER to do your work on the data rather than a SORT.
– Alex M
yesterday
As @AlexM mentioned use the filter function on your headings. the filter function can be found in the DATA tab of the toolbar. Make sure your data has no blank rows otherwise it will not be captured in the filter.
– angelofdev
21 hours ago