• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Worksheet Design Tips > Would Your Worksheet Survive Without You?

Would Your Worksheet Survive Without You?

If you are creating sheets that might at some point be used by others, make sure they are understandable and well documented. Most of us don't think about documentation, but every spreadsheet you create for business or personal use should be created with the possibility in mind that others will need to figure it out some day—possibly without your help. If you change jobs, you will be leaving a good legacy behind for the next person, which reflects well on you. A little documentation goes a long way, as shown in Figure 4-5. You can use Excel's Comment feature to add notes anywhere a little explanation is in order.

Figure 4-5. Make sure that critical worksheets are understandable and well documented.


Cross Reference

For information about documenting your worksheets, see “Adding Comments to Cells” on page 261.


You also need to prepare worksheets containing important personal records with survivability in mind. Not to sound too morbid, but if you were to unexpectedly shed this mortal coil, you wouldn't want to leave your family in the lurch because your financial worksheets are undecipherable.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint