| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking cells
I built a spread sheet that has text in one cell and more text in a second
cell. There are 200 rows of data like this. How do I link these cells so that they always stay together? In other words, if I sorted by alphabet I want the second cell to follow. Hope I'm not in trouble... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells
where is the second cell in relation to the first cell? above, below,
kitty-corner? "Nevada1" wrote: I built a spread sheet that has text in one cell and more text in a second cell. There are 200 rows of data like this. How do I link these cells so that they always stay together? In other words, if I sorted by alphabet I want the second cell to follow. Hope I'm not in trouble... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells
Mostly side by side like B1 and b2 but it could be B1 and B4.
I would want to include all cells in between B1 to B4 inclusive. "dlw" wrote: where is the second cell in relation to the first cell? above, below, kitty-corner? "Nevada1" wrote: I built a spread sheet that has text in one cell and more text in a second cell. There are 200 rows of data like this. How do I link these cells so that they always stay together? In other words, if I sorted by alphabet I want the second cell to follow. Hope I'm not in trouble... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linking cells
If you have all the text that you want to keep together in the same row, then
you can go to "Data" and select "Sort". When the new window opens, you can set your parameters to sort by whichever column you want. *If you have column heading be sure to select "Header Row" at the bottom so they will not be included in the sort. The default is to sort alphabetically by the first column. AQuigley "Nevada1" wrote: I built a spread sheet that has text in one cell and more text in a second cell. There are 200 rows of data like this. How do I link these cells so that they always stay together? In other words, if I sorted by alphabet I want the second cell to follow. Hope I'm not in trouble... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
| Linking cells, please help! | Excel Worksheet Functions | |||
| Linking cells | Excel Discussion (Misc queries) | |||
| Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
Linear Mode
