The Developer tab unlocks powerful automation tools in Excel—macro recording, Visual Basic for Applications (VBA), XML import ...

Excel offers simple methods to switch between viewing results and viewing formulas. Here is how to display formulas in Excel.

With this in mind, here are some of my favorite Excel hacks I've picked up over the years that you can take away and use to ...

If you want to show or hide the list of formulas while typing in an Excel spreadsheet, here is how you can do that. You can enable or disable the autocomplete of ...

If you want to display the formula in cells instead of calculated results in an Excel spreadsheet, here is how you can do that. It is possible to show the used or applied formula and hide the ...

How to Change a Named Range in Excel Whether you want to change the name of a range or the cells included within a named range, the process is quick and easy. In the Formulas tab on the ribbon ...

GPT Excel has six tool functions laid out on its landing page, including an AI Chat button to assist with any spreadsheet question. I turned to the Formulas tab for generating and understanding data.