Show all formula in an Excel Sheet

 

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.

 

image

No comments:

Post a Comment