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 ...

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.

When a reader asked how to create a group of custom views of a spreadsheet ( Technology Q&A , JofA , Jul.04, page 96), I suggested he give each section of the worksheet a unique name, which can be ...

Whether you're tired of losing your spot when collaborating or you want to customize the way you view your data, sheet views in Microsoft Excel are for you.

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

A. I love all things Excel, but the LAMBDA function is one I am most excited about. It allows you to build your own custom functions. LAMBDA is a relatively new function for users of Excel 365 and ...

Microsoft is overhauling Excel with the ability to support custom live data types. Excel users have been using Microsoft’s spreadsheet tool for decades to import, organize, and analyze data, but ...