Spreadsheet Cleanup

Get Directions

100%
Spreadsheet Cleanup — Get Directions original artwork

Pinch or use the controls to zoom. Drag to pan when zoomed in.

Open original full-size graphic

Get Directions

  1. StepDefine the cleanup scope

    Start with one simple sheet. Confirm improvements and values, formulas or columns that must stay unchanged.

    Source
  2. StepSave a copy and inspect

    Keep the original intact. Review headings, formats, blanks, possible duplicates, formulas and links.

    Source
  3. StepAgree on consistent rules

    Confirm dates, categories and capitalization. Preserve item codes and leading zeros.

    Source
  4. StepClean and flag carefully

    Apply approved corrections. Flag missing values and possible duplicates; do not guess or delete automatically.

    Source
  5. StepVerify and hand over

    Compare row counts, identifiers, formulas and relevant totals. Deliver a cleaned copy and change summary.

    Source