The image of the User Options dialog is clickable. As you move the mouse over each button, or group of buttons they will depress – click the depressed area to go to the description. If the buttons don't appear to depress then your browser doesn't support this function.
If the image isn't clickable, use this list of the buttons by section.
Startup position
How commas in numbers are handled
Spreadsheet scrolling options
Option for date conversions
Data box font, colour and position options
Data box selection check marks
Data boxes colour picker
Data boxes font picker
Data boxes text position selector
Active cell outline style and colour picker
Decimal places in display selector
Decimal places in Result box
Option not implemented
Move selection after paste selector
Access information about the company
Access frequently asked questions
Access information about reporting bugs
Close User Options and Customization dialog box & return to In–Cell
This option defines how the calculator positions itself on the screen. If the Auto option is selected, the calculator positions itself left or right
depending on the position of the selected cell, or top left of a selected range. The aim is to have the selected cell in–view and not obscured by the calculator.
This is not always possible, depending on the selected cell's position and the window width.
If left or right options are chosen, the calculator will
be positioned on the left or right side of the screen, respectively.
Commas have several meanings. In most English–speaking countries, the comma is used as a marker of groups of three digits, i.e., as a thousands separator,
although this is by no–means always used. In computer data, a format known as comma delimited has been used. It provides a simple indicator of the separation between
one item and the next. When those items are numbers, there is the possibility of confusion. In–Cell uses both definitions of the comma if the Auto option is selected.
In the Auto option, numbers with commas are extracted twice, once assuming that the commas are delimiters, separating individual numbers, and secondly, assuming that
the commas are defining thousands. In–Cell tests for groups of three digits, and if the groupings are compatible with a number with commas in it, the number is extracted.
As an example of the Auto setting, the digits 12,345,678 are returned as four numbers: 12; 345; and 678, based on commas as separators or delimiters and the number 12345678
based on the commas being thousands separators.
the digits 12,34,56,78 would be returned as the four numbers 12; 34; 56; and 78 as the commas did not define any groups of three digits (thousands).
When data to be handled is known to be comma separated or delimited data, set this option to Delimiters. If the data is not comma delimited, and may contain commas as thousands separators,
set the option to Thousands.
The way that the spreadsheet moves as the active cell position is changed is dependent on the No scroll check box on the calculator. The start–up state of the No scroll check box is
determined by this setting. Changes to the No scroll check box whilst using the calculator do not change this setting and hence do not alter the start–up state.
The conversion of numbers to dates can be limited by the use of the Only if date is after 01 January 1900 setting. When the Date special function button is used, In–Cell first checks for a single number in the
active cell. If a single number is present, a conversion to a date is made. Excel does not accept / convert negative numbers to dates, but In–Cell is able to convert negative numbers and these
are shown as dates before 1900, (see special functions Dates in Excel for more detailed information).
The Only if date is after 01 January 1900 setting stops conversion of negative numbers,
following Excel's limit.
This option may be revised in a future release to also force date serial numbers for the period from 01 January 1900 to 01 March 1900 to match the Excel date serial numbering, rather than the Visual Basic numbering,
the discrepancy being due to Excel's date serial numbering system including a serial number for the non–existant 29 February 1900. The Convert any number to a date option uses a consistent serial numbering,
with no number allocated for the non–existent 29 February 1900, and negative numbers allowed. Calculating the number of days between two dates, that spans 28 Feb / 01 March 1900 can be correctly calculated.
The calculator has eight data boxes, these are:
Each of these groups can be customized, (customization applies to all boxes in a group, i.e, customizing memory boxes applies changes to both memory boxes).
The customization avaliable is the background colour, the font colour, the font and the text position.
When options, such as colour are picked, they are applied to each group that has a check mark in one of the 4 check boxes. If all 4 boxes are checked,
the colour, font or position selected will be applied to all data boxes. The check boxes are not mutually exclusive, unlike radar
button groups, where only one selection in the group is possible. If making several changes, remember to deselect a group when moving on
to customize a different group.
Details of the colour picker, the font picker
and the text position selection are given in the following sections.
The colour picker and the font picker have been built as a Class module. 
By creating a class module for the colour and font picker, these functions are available for you to use in other VBA programing. This implementation of the colour picker is not a full implementation as described by
Microsoft, but it does have some useful features, such as the fact that a custom colour palette can be created and retained, and displayed
when the colour picker is next opened, (this does not happen in some implementations), also the colour previously selected can be made the
focus when the colour picker opens. The custom colours are available as a property of the class module, and are held as a single string which can be saved in 'your' program
and passed to the class module before calling it. In–Cell saves this custom colour string when it closes, and each user can create and save their own custom colours.
In this example one of the custom colours has been pre-selected – a colour I used as the background for the special functions data boxes.
The colour picker 'Define Custom Colors >>' button can be clicked to get the pallette, so that new custom colours can be selected.
The font picker can be set to open with a specified font displayed. The current font is highlighted if either only one data box is being changed,
or if all the boxes being changed at once have the same font. If the selected groups of data boxes use more than one font, then the default Tahoma font is highlighted.
To apply any of the font, colour or position settings, at least one of these check boxes must be selected. If all 4 boxes are checked,
the colour, font or position selected will be applied to all data boxes. The check boxes are not mutually exclusive, (unlike radar
button groups, where only one selection in the group is possible). If making several changes with different settings for different groups,
remember to deselect a group when moving on to customize the next group.
Note that the font previously in use for each data box is shown when the mouse is hovered over the appropriate check box. This information does not change until
the Options and Customization dialog is closed and re-opened.
There are two buttons - one for setting the colour of the font, the other for setting the background colour of the selected data box.
Before clicking either of these buttons, select which data boxes you wish to customize, using the check boxes above.
Each button opens up the colour picker. Select the colour required and click OK. Custom colours can be selected in the group of 16 colours at the bottom
of the colour picker. Click 'Define Custom Colors >>' to get the colour selector, and replace an existing custom colour with a new one.
The custom colour selection will be saved when In–Cell is closed. If Excel is closed without quiting In–Cell first, any new custom colours will not be saved.
Custom colurs are saved for each user.
If only one data box group is selected, or if all the groups selected have the same colour for font or background, the existing colour is highlighted in the colour picker.
If there is more than one colour, then the colour picker will open with its default colour selected, which is the colour in the top–left corner.
A default set of custom colours is supplied when In–Cell is first run, or if the colour data becomes corrupted.
Before clicking the Font button, select which data boxes you wish to customize, using the check boxes above.
The font used in each data box can be selected, e.g., Arial. Either Bold or Regular fonts can be selected. Although Italic is shown in the font picker, it is ignored by In–Cell.
The font size is selectable within certain limits. 
As the data boxes do not change size, some font/size combinations may not fit. The maximum selectable font size has been limited to 14 point
but this may still be too big in some fonts.
When the font picker dialog is first opened, the font highlighted is the one in use if a single data box has been selected. If multiple boxes have been selected, the font highlighted
is Tahoma, regular, 10 point, which is a reasonable font/point–size combination for In–Cell. When a new font is selected, on closing the font picker, the new
font is applied immediately to the calculator data box. If the font picker is re–opened without closing the
Options and Customization dialog, the font highlighted is the one just selected in the font picker. The original font used in the
data boxes can still be seen by hovering the mouse over the appropriate check box.
If the data box(es) are empty, 1234.000 is displayed in one of them, so that the effect of the change can be seen. This dummy data is
removed when the Options and Customization dialog is closed.
Before selecting a text position option, select which data boxes you wish to customize, using the check boxes above.
The position of the text in the box can be selected, left, centre or right.
In–Cell's Active Cell has an outline which can be changed. The outline style can be chosen from the single line styles,
Thin, Medium or Heavy, or line styles, dash, dot or double. The line colour button open the colour picker dialog box. Standard or
custom colours can be selected. The custom colour set is the same as that for fonts and text box backgrounds, and is saved
when In–Cell is closed. Each user can save an individual custom colour set, if In–Cell has been installed in the
user's Add–in directory, and each user has their own logon name and profile.
Note that when the Active Cell is selected in Excel, the colour pattern is inverted. The line colour is shown in this
section of the user option dialog box, but the line style is not displayed, only a single solid line is shown.
The number of decimal places displayed in the Result box can be changed. The spin buttons allow the number to be changed.
The number displayed is rounded to the set number of decimal places, but zero values are not displayed,
for example a value of 8.340 with the display set to three decimal places will only show 8.34. If the mouse is hovered
over the result box, a tip message is displayed indicating the maximum number of decimal places displayed.
When the number in the Result box is pasted to a spreadsheet cell or moved to an input, one of the memories or the clipboard, the full
value is transferred.
The direction that the Active Cell moves after certain operations is selectable. The three options are
'Right', 'Down' or 'None'. If 'None' is selected, the Active Cell is not moved after operations such as
a Paste. In general this is not an issue, although the user will need to be aware of the risk of
overwritting source data.
The double–click function available with paste multiple numbers and paste text to numbers is disabled
if the default move direction is set to 'none'.
The About button provides some basic information about the supplier of In–Cell,
the FAQ button provides a link to the FAQ page on this website, and
the Error button provides information on where to send information on bugs or other issues relating
to the calculator.
Clicking the 'Return to In–Cell Calculator' button closes the User Options dialog box, and returns to
the calculator. The user selected options and default values are used immediately by the calculator,
but the values are not saved permanently until In–Cell is closed.