ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I link several cells in a row together & sorting (https://www.excelbanter.com/excel-discussion-misc-queries/26745-how-do-i-link-several-cells-row-together-sorting.html)

Siy Blue

How do I link several cells in a row together & sorting
 
How do I link several cells in a row on one sheet so that when I sort any one
of the cells the rest of the cells will fallow

Bill Martin -- (Remove NOSPAM from address)

Siy Blue wrote:
How do I link several cells in a row on one sheet so that when I sort any one
of the cells the rest of the cells will fallow


You simply highlight the entire block that you want to keep together.
Then when you go into the sort routine and tell it to sort on column "B"
or whatever, the entire row you've marked will stay together as it gets
moved about.

Bill


All times are GMT +1. The time now is 07:34 AM.

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