| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect a block from line insert/delete
I have an Excel doc where there are two parts side-by-side. On the left is
the data that I manipulate - adding and removing lines as needed. On the right side are the labels that I copy into the left side. These do not change. If I add or remove a line on the left side, I'd like to know if there is a way to protect the right-side from line insertions and deletions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect a block from line insert/delete
If you have Excel 2003 you can create a List from the left side data.
Select range then DataList You can insert and delete rows within the List without affecting rows outside the list. Excel 2007 has re-named the feature to Table but functionality is same......I believe..........do not run 2007 so cannot verify. Versions earlier than 2003 did not have the feature. Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 07:58:00 -0700, lista72 wrote: I have an Excel doc where there are two parts side-by-side. On the left is the data that I manipulate - adding and removing lines as needed. On the right side are the labels that I copy into the left side. These do not change. If I add or remove a line on the left side, I'd like to know if there is a way to protect the right-side from line insertions and deletions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect a block from line insert/delete
I have Excel 2000...thank you anyway!
"Gord Dibben" wrote: If you have Excel 2003 you can create a List from the left side data. Select range then DataList You can insert and delete rows within the List without affecting rows outside the list. Excel 2007 has re-named the feature to Table but functionality is same......I believe..........do not run 2007 so cannot verify. Versions earlier than 2003 did not have the feature. Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 07:58:00 -0700, lista72 wrote: I have an Excel doc where there are two parts side-by-side. On the left is the data that I manipulate - adding and removing lines as needed. On the right side are the labels that I copy into the left side. These do not change. If I add or remove a line on the left side, I'd like to know if there is a way to protect the right-side from line insertions and deletions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect a block from line insert/delete
Cut the labels and move to another sheet.
Copy from there or refer to them from first sheet. Gord On Fri, 15 Aug 2008 09:27:01 -0700, meems wrote: I have Excel 2000...thank you anyway! "Gord Dibben" wrote: If you have Excel 2003 you can create a List from the left side data. Select range then DataList You can insert and delete rows within the List without affecting rows outside the list. Excel 2007 has re-named the feature to Table but functionality is same......I believe..........do not run 2007 so cannot verify. Versions earlier than 2003 did not have the feature. Gord Dibben MS Excel MVP On Fri, 15 Aug 2008 07:58:00 -0700, lista72 wrote: I have an Excel doc where there are two parts side-by-side. On the left is the data that I manipulate - adding and removing lines as needed. On the right side are the labels that I copy into the left side. These do not change. If I add or remove a line on the left side, I'd like to know if there is a way to protect the right-side from line insertions and deletions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alphabetize in a block, not just one line | Excel Discussion (Misc queries) | |||
| Protect / Block selected worksheet area . | Excel Discussion (Misc queries) | |||
| Block Protect | Excel Discussion (Misc queries) | |||
| How can I protect cells and allow users to insert/delete | Excel Worksheet Functions | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
