You could just as well use a range of A:G instead of
A1:G100 and be a lot less likely to need to update.
Actually the only thing I completely capitalize is zip state
codes and that is only one column so that might be E:E

related material in my
http://www.mvps.org/dmcritchie/excel/proper.htm