Keyboard shortcut and unsort?

[marwan1]

I'm using Excel 2007.

Two questions:

1- When we want to select a set of data we hold shift+Ctrl+right arrow and down arrow! Say I want the mouse to go to the first cell ie:A2 while the the sheet is selected, how can I do that?

2- I've sorted a set of data and saved them, now I want to return to previous format how can I do that?

Thanks guys so much for your help!

 

[Fazza]

hi, If I understand correctly.

1. CTRL-HOME then down arrow
2. ALT-D-F-S

HTH. regards

 

[marwan1]

Thanks Fazza.

Actually I want to return to the first cell while I'm on the selection criterea. Instead of scrolling up to cell A, I want to use a shortcut to get me up to the first cell while I'm selecting the whole table.

For the unsort I tried them but didn't work. what I meant is say I've sorted number of data then saved them,afterwhile needed to unsort them again to return to the beginning unsort table, can I do that?!

 

[Fazza]

If I understand correctly

1. CTRL-.
2. there is no such in-built short cut (to undo a sort after saving the file)

HTH

 

[marwan1]

Thanks Fazza!

If I read this right you're saying: (Ctrl + -) right!

For the unsort doesn't matter if there's a shortcut or not, I'm really looking for something to undo the sorting?

 

[Fazza]

No. That might delete rows/columns!

I should not have used the - symbol as a separator. Sorry.

So, NOT CTRL+-
Rather CTRL+.

That assumes you already have the selection. I'm not sure what you have...

To undo the sorting might be specific to your data. Maybe easier to add another field and populate it such as 1, 2, 3, 4, 5 in successive cells - obviously before you do the sorting you will want to undo. When you need to revert to that order, sort on the additional field.

 

[marwan1]

Also Ctrl+ could do the same as Ctrl-. Anyway it helps a lot!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
For the unsort I think it's ok to use your way or just isolate both sheets before and after sorting. I just wanted to confirm my understanding that there'sn't undo sort feature built-in!<o></o>
<o></o>
Thanks for your help!<o></o>