What are Circular References in Excel? A circular reference in Microsoft Excel usually refers to a formula that visits its own or another cell in a Workbook more than once in a single chain of ...

How to Go to Precedent Worksheets in Excel. Business owners and their office managers or accountants often need to check formula cells in Excel spreadsheets for potential links to a preceding cell ...

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

Navigating through a complex Excel workbook or spreadsheet can be a real headache, especially when you're dealing with multiple sheets and endless data.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.