Tips for Designing Spreadsheets: Part 1

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.

This entry was posted in Excel Spreadsheet Design. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>