Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |