keep cells together
 

How do I keep cells together in any given row. I'm creating a database where
it is imperative that the cells in each row stays with it's A,B,C,D, etc.
partners.

Whatever you have in say A1 to D500 will stay there forever unless you sort
the range without selecting the whole of it. Not really sure what you mean,
Regards,
Alan.
"Leaette" wrote in message
...
How do I keep cells together in any given row. I'm creating a database
where
it is imperative that the cells in each row stays with it's A,B,C,D, etc.
partners.

I presume Alan, guessed what you meant; otherwise, what would
a database have to do with anything. It is important to first choose
your Region.
http://www.mvps.org/dmcritchie/excel/sorting.htm#region

But for viewing you might be interested in Freeze Frames,
and for printing you might be interested in Rows to Repeat at Left
see http://www.mvps.org/dmcritchie/excel/freeze.htm
if not already familiar with the concept.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alan" wrote...
Whatever you have in say A1 to D500 will stay there forever unless you sort
the range without selecting the whole of it. Not really sure what you mean,

"Leaette" wrote ...
How do I keep cells together in any given row. I'm creating a database
where it is imperative that the cells in each row stays with it's A,B,C,D, etc.
partners.