For Windows users

Category: Cells and Ranges

The Cells & Ranges features empower you to manipulate and analyze large datasets with ease. Tools like Add Rounding, Add Custom Formula, and Change Formula References enhance formula management by automating common functions and adjusting references en masse. The Select All feature aids in quickly identifying specific types of cells, while Random Values and Random Sample generators facilitate data simulation and testing. These features streamline complex data tasks, ensuring precision and efficiency in data handling.

Random Sample

Quickly select random samples from large populations.

Random Values

Quickly generate random values of different types in bulk.

Change Formula References

This feature allows you to quickly switch each cell within the selected range between fixed and relative references.

Select All

This feature allows you to select all cells within the current worksheet that match a certain criterion.

Add Custom Formula

This feature allows you to quickly wrap all cells within a selected range in a custom formula.

Add IFERROR

This feature allows you to quickly handle errors within a selected range by wrapping all cells with an IFERROR function.

Add Rounding

This feature allows you to quickly add rounding to formulas and values within a selected range by wrapping all cells with a ROUND function.