1

When I select a cell range and go to Data>Sort Range>A to Z, it works perfectly!

but when I select a cell range and press Alt + D + S + A, then it gives me an error that few of my cells are merged (which they are), but those merged cells are not in the cell range I want to sort.

0

1 Answer 1

0

Wrong Shortcut

You are using the wrong keyboard shortcut:

  1. The keyboard shortcut for sorting ascending a range by the first selected column, where is a placeholder for that column letter,

    Data > Sort Range > Sort Range by Column <X> (A-Z)

    should be

    Alt+D R R *   or   Alt+Shift+D R R *
  2. The keyboard shortcut you are using,

    Alt+D S A

    is for sorting ascending the entire sheet by the first selected column, and since it is sorting the sheet, any merged cells outside the selection would be included.


* If you have 'Compatible spreadsheet shortcuts' enabled, you need to use Alt+Shift. If you do not, you can use either Alt+Shift or Alt.

The toggle is accessed using Ctrl+/ and under Help >Keyboard shortcuts

'Compatible spreadsheet shortcuts' toggle

3
  • 1
    what to do if I want to sort for example the "H" column? (Also Apologies, I didn't see your comment till now, I thought this question was closed by the website) Commented Jul 11 at 19:09
  • Alt+D R R and Alt+D R T (asc/desc) will always sort a range by its first column. To sort the range E2:I100 by column H ascending you would instead use Alt+D R S Tab Tab Tab Enter ↓ ↓ ↓ Enter Tab Tab Tab Tab Enter. To sort E2:I100 by column H descending you would use Alt+D R S Tab Tab Tab Enter ↓ ↓ ↓ Enter Tab → Tab Tab Tab Enter In both cases you need as many between the 2 Enter keys as the sort column is offset from the range's first column. You can see why mice have their place ;-)
    – Blindspots
    Commented Jul 12 at 0:15
  • @dudeAwesome I edited the answer with notes regarding "compatible spreadsheet shortcuts", and also clarified some of my explanation which was a bit imprecise.
    – Blindspots
    Commented Jul 12 at 1:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.