Previous Next

SurveyCTO's spreadsheet form templates and sample forms contain conditional formatting rules that will draw lines between lists on the choices tab and highlight fields on the survey tab. Generally, this formatting is helpful – particularly when you're starting out.

However, as you copy, paste, and insert rows in your form, Excel quietly duplicates all of the conditional-formatting rules. Everything might look fine on the surface, but behind the scenes Excel gets slower and slower as it struggles to handle a greater and greater number of duplicated formatting rules. At some point, this can become a real problem.

If your spreadsheet form definition has been edited so much and has gotten so big that Excel has become very sluggish, you might want to delete all of the conditional-formatting rules. To do so, you can click the Conditional Formatting toolbar button, then select Clear Rules From Entire Sheet. You will lose the nice formatting, but Excel will become speedy again. (Instead, if you're an Excel expert, you can just delete all of the duplicate rules and restore to one set that covers the entire sheet.)

Previous Next