4 ms·
Control-backtick toggles formulas. No need for VB(A).
by keithalewis 2y ago
Control-backtick toggles formulas. No need for VB(A).
- analog31 2y agoAh, I didn't know that. So I tried it. It does display formulas, but by hiding the values. What my macro does is allow the formula to be displayed permanently in its own column. Granted I'm one user out of many, and have switched to programming for any kind of quantitative work. but I'm still quite supportive of Excel.
- keithalewis 2y agoDo you realize it toggles data and formula display? That ought to be fine for anyone with more short term memory than a gnat.