Hover over each button to see an explanation or play the video tutorials.

Auto XLC - When Auto XLC is on it monitors changes to your spreadsheet and redraws equations immediately. Thus worksheet formulas and XLC names and equations will always be up to date. However if you are working with very large datasheets it may slow you down. In this case you should switch off Auto XLC and manually refresh equations using XLC redraw buttons. Auto XLC will switch itself off if it takes longer that the XLC dwell time (this is changed using the XLC Settings button). XLC Name - Name the adjacent right cell for use in XLC equations. The name button also includes some XLC text shortcuts to easily produce Greek characters and subscripts. Any character preceded by ‘|’ will be converted to its equivalent Greek character. All characters after the first will be automatically subscripted and it will end with ‘ =‘.  Note: if you remove the ‘ ‘ character before the final ‘=‘ automatic subscripting will not be enforced. Insert Equation - XLC searches to the left of the current selection for cells containing formulas. XLC draws a mathematical equation using XLC Names directly from cell formulas. Wherever XLC inserts an equation it will also insert an EQS( ) function with a reference to the cell formula being made into an equation and some display settings. Remember to use OVD( )/UND( ) functions in cell formulas to tell XLC what to display OVer the Division line and UNder the Division line. Table Name Tag - Use table name tags so that XLC can ‘name’ cells lying within a table. Name each column using XLC’s ‘Name Equation’ button and use table tags to refer to the row position. XLC will identify any cell in the table using the column name and row table tag. Algebra/Number - Equations can be shown in an algebraic form or a numeric form.  Note: use the ‘Clone Equation’ button if you wish to display in both forms. Clone Equation - Copy an equation located above the selected cell and change the form of the equation from algebraic to numeric and vice-versa. Format units - Replace numbers with superscripted numbers so that units are quickly formatted. Copy OVD( )/UND( ) - XLC uses its OVD( )/UND( ) functions to display OVer and UNder the equation Division line. You will use this construct a lot so copy it to the clipboard and paste into cell formulas quickly. Greek - Display a table of Greek characters and their XLC shortcuts. Any character preceded by ‘|’ will be converted to its equivalent Greek character but if you can’t remember your Greek alphabet this table will be a useful reminder. Remove XLC - Removing all XLC functions from the worksheet so that it can be read by any Excel user even if they do not have XLC installed. WARNING: when XLC functions are deleted equations become static graphic objects and will no longer update. It is advisable to take a copy of the XLC version before you use this button. Hide Equations - Removes all equation graphics from the worksheet.  Remember to use the redraw buttons to display the equations again. Redraw with Eqn No - The default equation number prefix is ‘Eqn’ but you can set it using the ‘XLC Settings’ button. Use this button to re-render all worksheet equations with the correct equation numbers. Equations are renumbered from left to right and then top to bottom. Correct equation numbering requires all worksheet equations to be redrawn. Note: Equation numbers are not shown when the ‘Auto XLC’ button is on. Redraw without Eqn No - Use this button to re-render all worksheet equations without displaying equation numbers. Make Movie - Change the active cell through a range of values and watch as the worksheet updates. This is particularly effective if charts are used. Process Text - Process text to produce mathematical notation quickly. Any character preceded by ‘|’ will be converted to its equivalent Greek character. Any character preceded by ‘_’ will be subscripted. All characters between square brackets will be subscripted. Any character preceded by ‘^’ will be superscripted. Select All Graphics - Selects all graphical objects on the worksheet. This is particularly useful for making sketches to group objects together without having to select each one individually. Note if you do not wish to include equations use the ‘Hide Equations’ button first. Chart XY Scales - This only works with XY scatter Charts. The button toggles between automatic XY scaling (to fit the chart window) or an equal scale for the X and Y axis (square grid). A square grid is useful to use scatter charts to draw sketches. Find ExcelCalcs - Search the ExcelCalcs site for template calculations. Email Worksheet - Donate a workbook to the ExcelCalcs repository. Publish your work on the ExcelCalcs website where your work will be appreciated by your fellow users. ExcelCalcs rewards any published content used with free subscriptions. Web Paste - HTML code for cell text and cell formulas can be copied from webpages and pasted into your workbook. See the eFormulas section of the ExcelCalcs website. XLC Help - A hyperlink to XLC help and tutorials on the ExcelCalcs website. XLC Settings - Insert your XLC release code to configure XLC in the XLC Pro mode. Set program preferences like equation prefix, force display of multiplication signs, change multiplication character, algebraic or numeric equations, vertical alignment, amazon site preference and Auto XLC dwell time (switch off automatic functionality if it is too slow).
AutoXLC.png AutoXLC.png When Auto XLC is on it monitors changes to your spreadsheet and redraws equations immediately. Thus worksheet formulas and XLC names and equations will always be up to date. However if you are working with very large datasheets it may slow you down. In this case you should switch off Auto XLC and manually refresh equations using XLC redraw buttons. Auto XLC will switch itself off if it takes longer that the XLC dwell time (this is changed using the XLC Settings button).
NameEqn.png NameEqn.png Name the adjacent right cell for use in XLC equations. The name button also includes some XLC text shortcuts to easily produce Greek characters and subscripts. Any character preceded by ‘|’ will be converted to its equivalent Greek character. All characters after the first will be automatically subscripted and it will end with ‘ =‘. Note: if you remove the ‘ ‘ character before the final ‘=‘ automatic subscripting will not be enforced.
InsertEqn.png InsertEqn.png XLC searches to the left of the current selection for cells containing formulas. XLC draws a mathematical equation using XLC Names directly from cell formulas. Wherever XLC inserts an equation it will also insert an EQS( ) function with a reference to the cell formula being made into an equation and some display settings. Remember to use OVD( )/UND( ) functions in cell formulas to tell XLC what to display OVer the Division line and UNder the Division line.
TableTag.png TableTag.png Use table name tags so that XLC can ‘name’ cells lying within a table. Name each column using XLC’s ‘Name Equation’ button and use table tags to refer to the row position. XLC will identify any cell in the table using the column name and row table tag.
NumAlgSwitch.png NumAlgSwitch.png Equations can be shown in an algebraic form or a numeric form. Note: use the ‘Clone Equation’ button if you wish to display in both forms.
Clone.png Clone.png Copy an equation located above the selected cell and change the form of the equation from algebraic to numeric and vice-versa.
FormatUnits.png FormatUnits.png Superscript any number within a text string so that units are quickly formatted.
CopyOVDUND.png CopyOVDUND.png XLC uses its OVD( )/UND( ) functions to display OVer and UNder the equation Division line. You will use this construct a lot so copy it to the clipboard and paste into cell formulas quickly.
Greek.png Greek.png Display a table of Greek characters and their XLC shortcuts. Any character preceded by ‘|’ will be converted to its equivalent Greek character but if you can’t remember your Greek alphabet this table will be a useful reminder.
UnXLC.png UnXLC.png Removing all XLC functions from the worksheet so that it can be read by any Excel user even if they do not have XLC installed. WARNING: when XLC functions are deleted equations become static graphic objects and will no longer update. It is advisable to take a copy of the XLC version before you use this button.
EraseEqn.png EraseEqn.png Removes all equation graphics from the worksheet. Remember to use the redraw buttons to display the equations again.
RedrawWithEqn.png RedrawWithEqn.png The default equation number prefix is ‘Eqn’ but you can set it using the ‘XLC Settings’ button. Equation numbers are not shown when the ‘Auto XLC’ button is on. Use this button to re-render all worksheet equations with the correct equation numbers. Equations are renumbered from left to right and then top to bottom.
RedrawWithoutEqn.png RedrawWithoutEqn.png Use this button to re-render all worksheet equations without displaying equation numbers.
MakeMovie.png MakeMovie.png Change the active cell through a range of values and watch as the worksheet updates. This is particularly effective if charts are used.
ProcessText.png ProcessText.png Process text to produce mathematical notation quickly. Any character preceded by ‘|’ will be converted to its equivalent Greek character. Any character preceded by ‘_’ will be subscripted. All characters between square brackets will be subscripted. Any character preceded by ‘^’ will be superscripted.
SelectAllGraphics.png SelectAllGraphics.png Selects all graphical objects on the worksheet. This is particularly useful for making sketches to group objects together without having to select each one individually. Note if you do not wish to include equations use the ‘Hide Equations’ button first.
ToggleXYScale.png ToggleXYScale.png This only works with XY scatter Charts. The button toggles between automatic XY scaling (to fit the chart window) or an equal scale for the X and Y axis (square grid). A square grid is useful to use scatter charts to draw sketches.
SearchForm.png SearchForm.png Search the ExcelCalcs site for template calculations.
Email.png Email.png Donate a workbook to the ExcelCalcs repository. Publish your work on the ExcelCalcs website where your work will be appreciated by your fellow users. ExcelCalcs rewards any content used with free subscriptions.
XLCHelp.png XLCHelp.png XLC help via tutorials on the ExcelCalcs website.
AboutXLC.png AboutXLC.png Insert your XLC release code to configure XLC in the XLC Pro mode. Set program preferences like equation prefix, force display of multiplication signs, change multiplication character, algebraic or numeric equations, vertical alignment, amazon site preference and Auto XLC dwell time (switch off automatic functionality if it is too slow).
  
Web Analytics