I strive to use the KISS method – Keep It Short and Simple – whether I’m creating a single, short spreadsheet or designing a complex workbook containing a series of large, related spreadsheets. Here is the first of two recommendations I have for designing spreadsheets in Excel:
All the content on a single sheet should (generally) be closely related. For example, if I’m responsible for a “Fun Day”, I might have one worksheet showing the names and contact information of the volunteers, and a second sheet to keep track of who is going to run each activity during the day.
Click here to open an Excel 2007 file (zipped, no macros) that contains a design I do recommend. Click here to open an Excel 2007 file (zipped, no macros) that contains a design I do not recommend.
