keep cells together

[Guest]

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.

 

[Alan]

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.

 

[David McRitchie]

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.