Learn Excel 365 formulas fast! From AutoSum to Intellisense, learn how to work smarter and analyze data with ease. Tips, ...

You’ll find it under the Formulas tab, in the Formula Auditing group. Once you open it, just hit Add Watch and select the cells you want to monitor. The pop-up will show you the sheet name, cell ...

When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the name isn't always so obvious. Although the Visual ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Have you ever stared at a beautifully organized table in Excel—rows and columns perfectly aligned—only to realize it’s a nightmare for analysis? Cross-tab layouts, while visually appealing, can feel ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Excel's main function is to interlink cells, through the use of formulas, so that the formula cell changes when data is inputted into linked cells. The best way to store information in spreadsheets is ...

In the January column (page 82) a reader asked how to display 36 workbook tabs in Excel. We described several solutions, but reader Mary Jo Gruber, a CPA with a St. Louis public school district, ...