StuffIKnowAboutComputersAndTheWeb > Fill Blanks With Values

Ever had an Excel file with, say, dummy variables that had the value of blank and 1 rather than 0 or blank?

  1. Edit > Go to
  2. Click Special
  3. Click Blanks
  4. Type in the value you want and hit Ctrl-Enter

Magic!

This page last modified on April 05, 2005, at 03:13 PM

This work is licensed under a Creative Commons License

Recent Changes | Page History | Edit Page