On my keyboard, that key is at the top left, just above the Tab key. On the keyboard, press the Ctrl key, and tap the ` key (accent grave). If you want to see all the formulas on a worksheet, instead of the results, you can use an Excel keyboard shortcut. In newer versions of Excel, you can make the formula bar taller, to its easier to work with long formulas. To drill into the formulas, the quickest and easiest way is to select a formula cell, and check the formula in the formula bar. Lets look at a couple of quick ways to troubleshoot Excel with Formula view, to see the worksheet formulas, and a simple trick for seeing both the formulas and the results. If you’re working in Excel, there are times when things don’t go right, and you have to do a bit (or a lot!) of troubleshooting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |