excel 問題

你試試下列方法是否滿意:
1. 在 B2 設定格式化條件
[Menu] - [格式] - [設定格式化條件]
設定 [儲存格的值] [等於] [=B1] (注意, 不要有$符號)
再按 [格式] button, 在更改 字形 的色彩=儲存格的底色 (一般為白色)


2. Copy and paste 去 B3, B4, B5 ......

以上方法是在未輸入 column A 數字時隱形了 formula, 希望幫到你.

假設b2,b3, ... 的數值不再變, 你可以select b2-b100, 然後copy and paste value 即可

I'm not quite understand you question, and have the following queries:

1: how to calculate A3? Is A3 = A2 + B2? If there is no formula for A3, there how could I "依此類推" for A4, A5, ...

2: You said "不想見formalla". Do you mean you don't want to see the cell value or really the formula in the cell? e.g. for cell B3, you don't want to see "80" or you don't want to see "=B2+A3"?

3: You said "問題是不想見formalla 在b2,b3,b4,b5..............等在儲存格出現". Do you mean you only want to see column A. For column B, it should appear as a blank column?


If the anser for query 3 is yes, then it is very easy. Just highlight the column B, and then choose font color to be white.