bs0d
Well-known Member
- Joined
- Dec 29, 2006
- Messages
- 622
I have a query in Column A. I'm adding and removing data in the columns to the right.
My problem occurs when I enter, and subsequently clearcontents in the same header row as the query in column A, excel automatically adds "column1". This would continue to "column2" and "column3" if I had data in columns B, C and so on.
The only way to get it to disappear is to delete the entire column(s). I cannot do this because it would break other references I have.
Is there a setting I need to disable or enable that prevents this auto formatting in Excel for my query?
My problem occurs when I enter, and subsequently clearcontents in the same header row as the query in column A, excel automatically adds "column1". This would continue to "column2" and "column3" if I had data in columns B, C and so on.
The only way to get it to disappear is to delete the entire column(s). I cannot do this because it would break other references I have.
Is there a setting I need to disable or enable that prevents this auto formatting in Excel for my query?