Excel spreadsheet bunching up when filter

[BelindaB]

When we filter the column's in excel by a type (e.g custom), and then filter
back to all, we loose a lot of the columns on the left hand side, they tend
to bunch up, and all have to be manualy re-opened.
is there a fix for this, we have tested it on office 2003 and 2007, but both
have the same issue. we are running xp pc's with sp3.

 

[Otto Moehrbach]

Belinda
Provide a bit of explanation of your terminology. When you say you
"filter the columns", what are you doing exactly? I mean, step-by-step,
what are you doing?
You say you filter by a "type". What are you doing?
You say you "loose a lot of the columns on the left....". "Loose" is a very
loose term. Exactly what do you see?
The same for "bunch up". Exactly what do you see?
What do you mean by "manually re-opened"? Exactly what do you do?
Please don't believe I'm being picky. Understand that you are talking to
people who have no idea what your problem is. HTH Otto

 

[BelindaB]

I apologise, this is my first time writing in one of these so I was unsure of
the format.
in excel spreadsheets when you have the same option appear reputedly, for
example state (qld, nsw) or month, (February, march etc), you can add them
into a drop down box to select for each column. In the drop down box, you get
the option to sort a-z, filter by qld, nsw etc or filter by all. When you
change to filter by qld, for example, it works fine, but if you then change
it to filter by all, the columns bunch up so only ½ appear. What I mean by
that is the columns bunch up is the vertical column 1 – 400 for example all
appear normal before the filter is applied, then I filter by state, then
remove the filter, several of the columns are missing, and in order to get
them back, I have to double click on the columns to make the others appear,
or close out of it and go back into it with out saving.

 

[BelindaB]

I apologise, this is my first time writing in one of these so I was unsure of
the format.
in excel spreadsheets when you have the same option appear reputedly, for
example state (qld, nsw) or month, (February, march etc), you can add them
into a drop down box to select for each column. In the drop down box, you get
the option to sort a-z, filter by qld, nsw etc or filter by all. When you
change to filter by qld, for example, it works fine, but if you then change
it to filter by all, the columns bunch up so only ½ appear. What I mean by
that is the columns bunch up is the vertical column 1 – 400 for example all
appear normal before the filter is applied, then I filter by state, then
remove the filter, several of the columns are missing,what i mean by missing
is they dont appear until you double click where they should be (in
sequential order). is there any reason why they would be bunching up?
Thank you

 

[Otto Moehrbach]

Belinda

I still don't follow what you have, what you do, nor what
happens. When you say "drop down box" do you mean Data Validation? What do
you mean when you say you "filter". I know what filter is but I don't
associate it with Data Validation. What version of Excel are you using?

Let's try this another way. Start with a new blank workbook and enter some
data into it to demonstrate your problem. Once you have a repeat of your
problem, tell me exactly what you did, step-by-step, starting from when you
had a new blank workbook. Your problem is not trivial but I can't help you
if I don't understand what you are doing. HTH Otto