Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep data together
I need to keep the contents of rows together, but allow users to freely edit
the contents of the cells. Users should be able to sort, but regardless of the range selection the data on any row must always stay together. Locking isn't the answer because users must then unlock the cells to edit or sort, and then they can also move a cell's contents out of the row with the other information that it specifically relates to. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep data together
Before sorting, make sure you have ALL columns selected.
Do not let Excel guess what the sort range is. If this is not what you need, post back with more details and/or a sample of your layout. Gord Dibben MS Excel MVP On Fri, 18 Sep 2009 11:08:01 -0700, Daniel wrote: I need to keep the contents of rows together, but allow users to freely edit the contents of the cells. Users should be able to sort, but regardless of the range selection the data on any row must always stay together. Locking isn't the answer because users must then unlock the cells to edit or sort, and then they can also move a cell's contents out of the row with the other information that it specifically relates to. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep data together
not sure I understand fully. Can you create a column to identify the order
or grouping you need to be able to get back to what you need? you can protect that column but still allow users to sort / edit non protected fields. If you can provide some examples "Daniel" wrote: I need to keep the contents of rows together, but allow users to freely edit the contents of the cells. Users should be able to sort, but regardless of the range selection the data on any row must always stay together. Locking isn't the answer because users must then unlock the cells to edit or sort, and then they can also move a cell's contents out of the row with the other information that it specifically relates to. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep data together
Let me put it another way - I want to be able to lock the cells of an entire
row so that any cell in a given row cannot be moved separately from the other cells in the same row. For example, let's say I have data in rows 1 thru 5 in columns A thru F. I need the contents of 2A thru 2F to be "joined" or "grouped" together so that if any cell in row 2 is moved to - let's say - row 10, ALL cells in row 2 are moved with it so that the contents of row 10 looks like row 2 used to. Users should still be able to edit the cell contents, but any one cell must not be able to be moved out of relationship with other cells in the same row. "Don" wrote: not sure I understand fully. Can you create a column to identify the order or grouping you need to be able to get back to what you need? you can protect that column but still allow users to sort / edit non protected fields. If you can provide some examples "Daniel" wrote: I need to keep the contents of rows together, but allow users to freely edit the contents of the cells. Users should be able to sort, but regardless of the range selection the data on any row must always stay together. Locking isn't the answer because users must then unlock the cells to edit or sort, and then they can also move a cell's contents out of the row with the other information that it specifically relates to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |