Tiger Chen
01-07-2007, 02:21 AM
The attached Excel sheet is not protected. There is no VBA code inside. We can format cells in green zone as normal - via formatting menu bar or "Ctrl+1" format cells dialogue box.
However, we cannot call the format cells dialogue box via Ctrl+1 shortcut nor cells popup menu by right clicking on the cells for the cells in yellow zone. (Format cells command is not faded on the cells menu.)
We can set the Font format and fill patterns for the cells in yellow zone. But we cannot change the border setting (Actually, there is no borders for the zone by checking from Style - modify...)
We can remove the limitation on yellow zone by change the style - modify... or by selecting both yellow zone and other zone, and then change the format.
(I also did some trials on copy - paste ranges. There are some special effects with different operations. Ignored here.)
How can we create this limitation? How to explain it in Excel?
This is a discussion on www.excelhome.net (http://www.excelhome.net).
One reasonable explanation is that when we copy data from other application like ERP or SAP, we can get this kind of effect sometimes. But this is not confirmed and we cannot explain it.
So, please help! Thanks!
However, we cannot call the format cells dialogue box via Ctrl+1 shortcut nor cells popup menu by right clicking on the cells for the cells in yellow zone. (Format cells command is not faded on the cells menu.)
We can set the Font format and fill patterns for the cells in yellow zone. But we cannot change the border setting (Actually, there is no borders for the zone by checking from Style - modify...)
We can remove the limitation on yellow zone by change the style - modify... or by selecting both yellow zone and other zone, and then change the format.
(I also did some trials on copy - paste ranges. There are some special effects with different operations. Ignored here.)
How can we create this limitation? How to explain it in Excel?
This is a discussion on www.excelhome.net (http://www.excelhome.net).
One reasonable explanation is that when we copy data from other application like ERP or SAP, we can get this kind of effect sometimes. But this is not confirmed and we cannot explain it.
So, please help! Thanks!