Formatting Spreadsheets for the Data Validation Center

  • Remove any passwords
  • Highlight entire spreadsheet
    • Format: General
  • Highlight SS# row
    • Right click
    • Format cells
    • Special
    • Social Security Number
  • If there are any borders or additional sheets they will need to be removed
  • Save
  • “Ctrl” & “End” – this should bring you to the last cell with a number in it.
  • If not, delete rows/columns between your highlighted cell and last cell.
  • Save again
  • “Ctrl” & “End”
  • You may only have one header row and one footer row