| Printer Friendly Version |
|
|
Excel Template is a useful tool to allows your teammates to input data in a pre-defined way. This standard template makes the consolidation work easily. To make your Excel template even better, you should take care on the following tips.
#1 - Protect from Input
You should identify which cells/worksheets that are not for input. These cells/worksheets should be set as "Protected".
#2 - Coloring your template
Use different background color or font color to indicate the cells for input or read-only. It is common to set those cells for input data with a lighter color (e.g. yellow). For those read-only cells, you can set it with a darker color (e.g. gray) or set the text to become gray.
You can use other colors like Red, Green for highlight. It's always true to have a Key/Legend to explain your color usage.
#3 - Use border to set region
Border is very simple but useful tool to make your worksheet much clearer. It can gives user a clear picture about different parts of the worksheet.
#4 - Hide Cells
Unused cells are always the source of confusion. User always asks for: what should I do with this cell? What is this cell?
Hide unused cells to avoid any confusion.
Related Articles:
"Shift" key make something in Excel difference
|
If you have any comment or inquires,
please send email to editor@evinco.com.hk
You have permission to reprint the article. Use it in your ezine, at your website or in your newsletter. The only requirement is including the following statement: "Article by Evinco Solutions Limited, visit www.evinco.com.hk for more original content like this." |
Evinco Editor
|
Back to Knowledge Sharing
Column
Home Page
|
