If you need to create pivot tables based on a dynamic named range that will expand as you add additional rows of data you. If just selecting complete columns blank values will show up in the pivot filters.