If you have ever used Excel to gather information from people in a pre-defined form setup, you know it can be frustrating when the responses contain added rows, columns, comments out of sight, etc. The purpose of taking the time to set up a form is so that you can get your data in a consistent format/layout. It's actually pretty easy to protect your worksheet from people who … [Read more...]
Too Many Different Cell Formats in Excel
If you have ever received the "too many different cell formats" error message in Excel, stop what you're doing, take a look around your workbook and ask yourself "are all these cell formats really useful?" After you answer the inevitable "no", smack yourself in the back of the head for creating such a mess! Just kidding, don't actually smack yourself, but apologize to your … [Read more...]