- .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:
- Painter 現(xiàn)代服裝效果圖表現(xiàn)技法
- Excel圖表與表格實戰(zhàn)技巧精粹
- SOLIDWORKS Visualize 實例詳解（微視頻版）
- Photoshop CC 2017從入門到精通
- Adobe創(chuàng)意大學Illustrator CS5 產品專家認證標準教材
- 邊做邊學：平面廣告設計與制作（Photoshop 2020+Illustrator 2020·第3版·微課版）
- 快學熟用D3
- Adobe創(chuàng)意大學Photoshop產品專家認證標準教材（CS6修訂版）
- AutoCAD入門教程全掌握
- 中文版3ds Max 2014-VRay效果圖制作完全自學教程
- 原片蛻變：Photoshop CC商業(yè)修圖必修課
- 24小時玩賺剪映
- Mastercam 2019 完全自學寶典
- Instant Apache Sqoop
- Mastering Redis