ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I want to sort selected cells in Excel, not entire rows. (https://www.excelbanter.com/excel-discussion-misc-queries/28817-i-want-sort-selected-cells-excel-not-entire-rows.html)

Aeryn635

I want to sort selected cells in Excel, not entire rows.
 
Has Microsoft Excel changed? I want to sort my selected cells, and not the
entire row! Also, Excel keeps extending my selection to adjacent rows with
data in them whether I use the sort shortcut button, or sort from the data
menu.

Peo Sjoblom

No, it hasn't change, you can select a range and only sort that range, you
should get prompted if the adjoining cells has values but then you select
"continue with current selection"


Regards,

Peo Sjoblom

"Aeryn635" wrote:

Has Microsoft Excel changed? I want to sort my selected cells, and not the
entire row! Also, Excel keeps extending my selection to adjacent rows with
data in them whether I use the sort shortcut button, or sort from the data
menu.



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com