Tip of the Day | Thursday 30 July 2026

This tool displays detailed information about your Excel workbook, the active worksheet, and your current selection.

It provides the following information:

File details:

• File name
• File size
• Last modified date
• Number of sheets in the workbook

Active sheet details:

• Sheet name
• Used range address
• Last row and last column used
• Total number of cells in the used range
• Number of cells with formulas
• Number of blank cells
• Number of constants (non-formula values)
• Number of cells with errors
• Number of logical (TRUE/FALSE) values
• Number of text values
• Number of numeric values

Selection details:

• Address of the active cell
• Row and column number of the active cell
• Address of the selected range
• Number of columns, rows, and cells in the selection

This overview helps you better understand the structure of your file and selection.

Starting this tool