Show all formula
You can view all the formula on the worksheet by pressing Ctrl and `.
The ' is the left single quote usually found on the key to left of number 1.
Press Ctrl and ` to see the formula below. (The screen may look a bit odd.)
Press the same combination to see the original view.
You can view all the formula on the worksheet by pressing Ctrl and `.
The ' is the left single quote usually found on the key to left of number 1.
Press Ctrl and ` to see the formula below. (The screen may look a bit odd.)
Press the same combination to see the original view.
B
|
C
|
D
|
|
9
|
10
|
20
|
30
|
10
|
30
|
40
|
70
|
11
|
50
|
60
|
60
|
12
|
70
|
80
|
30
|
After pressing shortcut key, above table will reflect as shown in below table:
B
|
C
|
D
|
|
9
|
10
|
20
|
=B9+C9
|
10
|
30
|
40
|
=SUM(B10:C10)
|
11
|
50
|
60
|
=MAX(B11:C11)
|
12
|
70
|
80
|
=IF(B12>C12,B9,B10)
|
No comments:
Post a Comment