Check Templates / December 17, 2018 / Clarissa Mendoza
The background of the area where I want my team to enter the data is always a lighter color with the headings backgrounds being formatted with a darker color. This strategy is in line with that used in software development. You will notice in applications like Microsoft Word you always type the text in the lighter area and the darker area is the headings. The flip side is that if your background is a light color then the text being entered must be a dark color and for the headings if your heading backgrounds are dark then the text should be light. Always be carefully when using the colors Red Green and Blue on templates as people with color blindness can find those colors confusing.
Look on the left side of your new window screen until you see Microsoft Office Online. Click on the category that you are interest in (for example budgets calendar etc) You will see templates appear for that category. Select the template that looks interesting to you. Click OK. Once downloaded this template can be modified saved and re-used as often as you need it. Excel 2003 Excel 2003 has templates located on your computer and ones that can be downloaded directly from Microsoft.com. Downloading templates to Your Computer To download templates directly to your computer follow these steps: Select File and then New.
Previous to this I recommended that you use protection at the worksheet and cell level to restrict the access people can have to certain cells. The workbook also should be protected to ensure that your users cannot modify the underlying template. You can set two levels of security which are the Modify option and Read Only Option. The only time you would use the Read Only option is if your template was only being used to print out the data. Issue 3: Use Formatting to make it easy to know where to put the data There are some basic fundamentals I always follow when it comes to formatting in Microsoft Excel.