Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Be able to select rows and columns and simply click DO NO SORT

It is a massive ball ache sorting when it should not be this aggravating. Maybe I'm being stupid and there is a simple solution already, but I can't find it online and I can't figure it out myself.
My annoyance is that I generally need to sort when I have multiple rows with text for headers, and some boxes need merging.

I'll explain because some people say "do not merge", but this isn't always helpful.
Current excel spreadsheet I'm working on.
I included a picture of my spreadsheet so you can see. I want those top 3 rows to never be included in sorting. I think I should be able to just highlight them and right click, or go to the sorting tab, and click, do not sort selected cells.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    already supported  ·  Dan Battagin [MS XL] responded  · 

    Hi,

    You can achieve what you’re asking for by inserting a blank row between rows 3 and 4 (where you don’t want any sorting to happen above the blank row).

    You can then make the row height very small (1px or so) so it doesn’t take up room on your sheet.

    Then, when you sort the content in your table, it won’t sort the headers.

    Hope that helps,
    Dan [MS]

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base