Check Templates / December 20, 2018 / Nanette Watson
All that you have to do is click a couple of keys and then you can change it around to the point that you want it to be at allowing you to see what needs to be changed. Something else that you can discover is that these templates will cut weeks off of the time that you would have spent developing them yourself. Since they will cut so much time off of the planning and tracking aspects you will see that the project can be completed even faster. Being able to use a form of project planning steps is going to be a great thing. The problem that you can encounter though is not knowing that the Excel templates offer a great solution for you to use.
The other issue to watch with formatting is to ensure that your colors print out correctly especially if you have used color on the screen but it prints out in black and white. Some colors do not print out well on black and white printers. Issue 4: Hide Unused Cells One of the biggest mistakes I see people do with templates is to not hide any unused cells. Having unhidden cells runs the risk that your team may put in information in the wrong position or they may believe they need to put more information in than they need to. Always hide your unused cells.
By this I mean you have a spreadsheet that you use daily weekly or monthly. You may have to modify a few cells but the remainder of the spreadsheet is exactly the way you want it. It may be tedious to modify the cells but it is easier than recreating it from scratch. Guess what you have the basis of a template! If you wanted to make this spreadsheet into template you would need to take two more steps. The first step would involve modifying the spreadsheet to display only the data that remains the same. If you are constantly changing certain cells you would leave these cells formatted but blank. The last step involves saving this spreadsheet as a template. Once this is done you would always have access to a clean spreadsheet that is formatted the way you want and ready for your modifications.