Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Leaette
 
Posts: n/a
Default 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.
  #2   Report Post  
Alan
 
Posts: n/a
Default

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   Report Post  
David McRitchie
 
Posts: n/a
Default

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
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
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 07:21 PM.

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"