| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Microsoft Excel should allow layers that can be turned on and off.
I use Excel to capture geologic data most of which is heavily formatted for
visual display and ease of understanding. When I cut and copy data in cells, sometimes the format is cut or copied as well. I would like Excel to have a layer on which the format is applied and the data residing on a different layer. When the format layer is locked, a cut or copy or paste only affects data, not the format. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel should allow layers that can be turned on and
"Paste Special" works great, if you know about it. Unfortunately, a lot of
end-users don't. When you create, format, and protect a worksheet for use by others, it would be nice if the formatting would remain protected from people using "Paste". "Peo Sjoblom" wrote: Editpaste special there you have different options like values, formulas and formats -- Regards, Peo Sjoblom (No private emails please) "Rock Jock" <Rock wrote in message ... I use Excel to capture geologic data most of which is heavily formatted for visual display and ease of understanding. When I cut and copy data in cells, sometimes the format is cut or copied as well. I would like Excel to have a layer on which the format is applied and the data residing on a different layer. When the format layer is locked, a cut or copy or paste only affects data, not the format. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel should allow layers that can be turned on and
If as you say you have protected the worksheet, and not unlocked the cells,
then the formatting is protected. In 2002 onwards you are also given a lot of control over what is protected and what isnt, in case you wish to allows users to do certain things. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Elkar" wrote in message ... "Paste Special" works great, if you know about it. Unfortunately, a lot of end-users don't. When you create, format, and protect a worksheet for use by others, it would be nice if the formatting would remain protected from people using "Paste". "Peo Sjoblom" wrote: Editpaste special there you have different options like values, formulas and formats -- Regards, Peo Sjoblom (No private emails please) "Rock Jock" <Rock wrote in message ... I use Excel to capture geologic data most of which is heavily formatted for visual display and ease of understanding. When I cut and copy data in cells, sometimes the format is cut or copied as well. I would like Excel to have a layer on which the format is applied and the data residing on a different layer. When the format layer is locked, a cut or copy or paste only affects data, not the format. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel should allow layers that can be turned on and
True, in that case the formatting is protected, but what if you want to allow
users to input data? The cells would then need to be unlocked. The cells are still protected against manual formatting changes, but "Paste" overrides this protection. "Ken Wright" wrote: If as you say you have protected the worksheet, and not unlocked the cells, then the formatting is protected. In 2002 onwards you are also given a lot of control over what is protected and what isnt, in case you wish to allows users to do certain things. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "Elkar" wrote in message ... "Paste Special" works great, if you know about it. Unfortunately, a lot of end-users don't. When you create, format, and protect a worksheet for use by others, it would be nice if the formatting would remain protected from people using "Paste". "Peo Sjoblom" wrote: Editpaste special there you have different options like values, formulas and formats -- Regards, Peo Sjoblom (No private emails please) "Rock Jock" <Rock wrote in message ... I use Excel to capture geologic data most of which is heavily formatted for visual display and ease of understanding. When I cut and copy data in cells, sometimes the format is cut or copied as well. I would like Excel to have a layer on which the format is applied and the data residing on a different layer. When the format layer is locked, a cut or copy or paste only affects data, not the format. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Microsoft Excel should allow layers that can be turned on and
If you unlock the cells then they are not protected against manual
formatting changes. Agreed though, there is no easy way to do what you want. Regards Ken................... "Elkar" wrote in message ... True, in that case the formatting is protected, but what if you want to allow users to input data? The cells would then need to be unlocked. The cells are still protected against manual formatting changes, but "Paste" overrides this protection. "Ken Wright" wrote: If as you say you have protected the worksheet, and not unlocked the cells, then the formatting is protected. In 2002 onwards you are also given a lot of control over what is protected and what isnt, in case you wish to allows users to do certain things. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Elkar" wrote in message ... "Paste Special" works great, if you know about it. Unfortunately, a lot of end-users don't. When you create, format, and protect a worksheet for use by others, it would be nice if the formatting would remain protected from people using "Paste". "Peo Sjoblom" wrote: Editpaste special there you have different options like values, formulas and formats -- Regards, Peo Sjoblom (No private emails please) "Rock Jock" <Rock wrote in message ... I use Excel to capture geologic data most of which is heavily formatted for visual display and ease of understanding. When I cut and copy data in cells, sometimes the format is cut or copied as well. I would like Excel to have a layer on which the format is applied and the data residing on a different layer. When the format layer is locked, a cut or copy or paste only affects data, not the format. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
