The Forms Toolbar in Microsoft Excel

When opening a form for data entry in Microsoft Excel, you have access to a Forms toolbar, in addition to the Excel functionality.
Table 1. Forms toolbar functions in Microsoft Excel
Button Name Description
Select Form Select form Click this button if you want to open another form.
Create Layout Create layout Click this button to regenerate the layout. Note that and all existing formatting will be lost.
Update Layout Update layout Click this button to update the contents of the form, without clearing all previous formatting.
Standard Colors Standard Colors Click this button to re-set all color coding to standard colors.
Number format Number format Click this button to define if you want to use thousand separator and how many decimals the cell should display. This option gives you the possibility to ignore the decimal settings made in the Regional Options setup on the server where IBM® Cognos Controller is installed. Note that you have to set number of decimals for each account in Account Structure - Define.
Layout Options Layout options Click this button to define settings for the scroll area, grid offset and viewable area. Note that you can have different print and view areas.
Show Show Click this button to view system rows and columns.
Hide Hide Click this button to hide system rows and columns.
Undo all Undo all Click this button to undo all the changes that you have made to the form since you last saved the form.
Save Layout Save Layout Click this button to save the changes to the form.
Help Help Click this button to display the online help for Layout.