Principles of Good Worksheet UI Design
The following list provides some design guidelines that apply to all worksheet user interfaces:Use formatting to create visual contrast between cells designed to serve different purposesinput cells versus formula cells, for exampleas well as visual separation between different sections of your user interface.Use consistent formatting based on the purpose of each cell. For example, don't format input cells with a white background in one area and a green background in another.Don't use garish colors. Your choice of formatting should not distract from the task at hand.Create a logical, well-structured flow through your user interface. Your user interface should flow from left to right then top to bottom within a worksheet and from left to right among multiple worksheets.Make it obvious to users what they are supposed to do each time they are required to perform some action. Techniques for doing this include the use of cell comments, validation lists, default values, good descriptive field names and so on.Use dynamic input-verification techniques to provide feedback as quickly as possible if the user has done something wrong. Waiting until the user has completed the entire form to point out data-entry errors should be viewed as a last resort, to be used only when there are no good alternatives.Don't create an environment that potentially allows the user to make catastrophic mistakes. Protect all of your user interface worksheets, leaving only cells that require data entry unlocked. This prevents critical formulas from being accidentally overwritten.Don't allow the user to get lost. Restrict the area of the worksheet within which the user can navigate to the working area of your user interface. |
لطفا منتظر باشید ...
