Workbook and Selection Details...

ASAP Utilities › Info & List › 2. Workbook and Selection Details...

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.

Screenshots

Info & List › 2 Workbook and Selection Details...

Starting this tool

Click ASAP Utilities › Info & List › 2. Workbook and Selection Details...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Excel file info, workbook details, show file properties, active sheet info, used range details, cell types summary, selection details, selected range info, get workbook statistics, number of sheets in workbook

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Analyze Selected Cells: Count, Sum, and More...

Copy Full File Path of Workbook to Clipboard

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.