Open – Click to open a different project.
| |
Save – Click to save project changes.
| |
Print – Click to print.
|
Simulated Screen - Click to view workbook on different screen sizes and orientations for mobile phones or tablets.
| |
Save Encrypted - Click to save the current XML project, then export to a new compressed, encrypted ERT file for customer distribution.
| |
Recalculate Cells – Click to recalculate all cells on all sheets.
|
Variables – Click to add, edit, view or delete Script variables.
| |
Script Edit – Click to present the Script Editor.
| |
Script Run – Click to run script for a simulated event or button click.
|
Sheet Add Delete – Click to add, delete or reorder sheets in the workbook.
| |
Workbook Properties – Show or hide sheet column and row headers, scrollbars and gridlines. Rename sheets or make them Visible or Invisible.
| |
Sheet Size – Change the number of Columns and Rows on the current sheet.
|
Erase Cell Data – Select a Column and Row range. Selectively delete cell properties.
| |
Cell Size & Visibility – Change the Column Width, Row Height or visibility of columns and rows.
| |
Cell Range Copy – Copy selected properties for a range of cells into the clipboard.
|
Cell Range Paste – Paste selected properties for a range of cells into the current sheet.
| |
Cell Properties – Click to edit cell properties for a selected cell or range of cells.
| |
Range – Click to add, edit, delete or view named ranges used in formulas.
|
Format Rules – Click to add, edit, delete or view conditional formatting rules.
| |
Hyperlinks – Click to add, edit, delete or view Hyperlinks assigned to a range of cells.
| |
Table Add Delete – Click to add, edit or delete tables within the project. Tables overlay extra properties on a range of cells.
|
Sheet Filter – Enable or disable a sheet filter for a range of cells on the current sheet.
| |
Control Add Delete – Click on the screen to add or delete a Form Control. The Add Form Control dialog is presented to define the control name, type, width and height.
| |
Control Edit – Click on a screen Form Control to edit it. Double-click tool to present the Form Controls dialog to Add, Edit, Delete or View all project form controls.
|
Control Move Resize – Click in the top left quadrant of form control to move it or click the bottom right quandrant to resize it.
| |
Cell Control – Click on any cell to create an inline cell control. A cell control is drawn within a specific cell.
| |
Cell Borders – Click on any cell to assign borders to one cell or a range of cells.
|
Cell Validation – Click on any cell to set entry validation rules, input messages and alert messages.
| |
Cell Text Color – Click to change font, size, color, style and other text properties of a cell.
| |
Cell Background – Click to change background color and pattern for a cell or add an icon.
|
Sheet Background Image – Click to add or remove a background image for the current sheet.
| |
Cell Range Move – Click to move a range of cells and related properties on the current sheet.
| |
Training Videos – Learn ExcelRT Builder with free training videos.
|