Ian's Excel Add-in Ribbon Menu

Items under the Numeric Functions menu are used to manipulate values or formulae.

Round Off adds the Excel round function to the value or formula in the cell or range of cells selected.

Ceiling adds the Excel ceiling function to the value or formula in the cell or range of cells selected.

Markup by Value marks up the value or formula in the selected cell, or range of cells, by a fixed percentage entered by the user.

Markup by Cell Reference marks up the value or formula in the selected cell, or range of cells, by adding a reference to another cell selected by the user.

Auto Number automatically adds numbering to the leftmost cells in the selected range, if the cells included in the selected range to the right of each are not blank.  The top left cell in the range is assigned a value of 1 if it is blank, or contains text.  If it already contains a numeric value, the numbering will increment using the existing value as a start value.

WARNING:  Auto Number clears the contents of all visible cells in the leftmost column of the selected range before adding new numbering!

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.