Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Siy Blue
 
Posts: n/a
Default 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
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with link cells between 2 spreadsheets Wellie Excel Discussion (Misc queries) 2 May 12th 05 05:30 AM
How to link cells and keep number format altogether Yi Excel Discussion (Misc queries) 0 May 6th 05 02:12 PM
How do I link cells and keep the formating in excel? thanksforthehelp Excel Discussion (Misc queries) 4 April 8th 05 03:53 PM
How do I link many cells to one particular cell? fish@divi Excel Discussion (Misc queries) 2 January 4th 05 11:00 PM
How do I link many cells to one particular cell? justinfishman22 Excel Discussion (Misc queries) 2 January 4th 05 12:09 AM


All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"