One way I could replicate this is if I used Data|List for that range (A:G).

Anything special you're working with????

protected sheet, merged cells, lists, ....

Lauri wrote:

Excel spreadsheet has 7 columns. I want to leave columns A-D as is and only
sort the data in columns E-G. When I select the required data and click on
sort, Excel is automatically selecting the entire spreadsheet. How do I only
get the three columns?

--

Dave Peterson