Troubleshoot Excel in Formula View
✅ Get the sample Excel file to follow along ► https://myctx.link/wksh
🔵 When you're working with Excel, you can use the Formula View, to help with troubleshooting. In this video, you'll see how to switch to Formula view, by using a keyboard shortcut.
To compare the formula results, and the Excel formulas, you can open two windows in the same workbook. See how to create a new window, and arrange the window, to see both the formulas and the results.
💡 Related Links 💡
Excel Worksheet Tips ► https://myctx.link/wksh
More Excel Tips & Videos ► https://myctx.link/TipsXL
🔴 Related Excel Videos 🔴
Auditing Excel Formulas ► • Auditing Excel Formulas - Quick Tips
✅ Excel resources I recommend ► https://myctx.link/xlpick
⏰ Video Timeline ⏰
0:00 Worksheet with Formulas
0:28 Show/Hide Worksheet Formulas
1:13 Open a Second Window
2:21 Close the Second Window
🔶 Instructor: Debra Dalgleish, Contextures Inc.
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips