- .NET 4.0 Generics
- David Lai Xavier Hacking
- 199字
- 2021-04-02 19:30:09
Debugging your spreadsheets
It is common that Dashboard Design developers may accidently put in the incorrect formula when developing logic on their spreadsheets. Using the Ctrl+` hotkey will make things much easier.
How to do it...
- Select the worksheet you want to see formulas for.
- Hit the Ctrl key and ` (grave accent) key together.
- You will see the value in the cell change to the formula.
How it works...
The hotkey Ctrl +` works by showing the underlying formula of a cell. This is extremely useful if you are comparing formulas from multiple cells, the reason being that the developer does not have to flip between formulas in order to see what they are doing wrong when comparing multiple cells. Developers can quickly analyze their worksheet and find the cause of their problem quickly.
The following screenshot shows the results of two Excel formulas in cells A1 and A2:
After using the Ctrl+ ` hotkey, the formulas of both cells are displayed as you can see in the next screenshot:
- MATLAB計算機視覺經典應用
- CorelDRAW X6圖形設計立體化教程
- Microsoft SharePoint 2010 Power User Cookbook: SharePoint Applied
- Python數據分析實戰：從Excel輕松入門Pandas
- Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
- 中文版CorelDRAW X8基礎培訓教程（全彩版）
- 詳解AutoCAD 2022機械設計（第6版）
- AutoCAD 2022中文版建筑設計從入門到精通
- 修片有道：PHOTOSHOP攝影后期專業技法
- PKPM 2010結構分析從入門到精通
- 平面設計師實戰教程
- Joomla! 1.5 Top Extensions Cookbook
- 同花順軟件操作技巧與實戰指南
- CorelDRAW 2017從新手到高手
- 平面設計師職業教程（Photoshop技能實訓）