eliminating unneeded columns

I am currently working with a comma delimited file with approx. 1450 columns
and I can't use them all. The spread sheet only needs 25 columns. I am trying to save time from deleting the unneeded columns manually. I have identified the columns and have highlited and color filled them so they are obvious while I highlight and delete those columns between the color filled columns. I have also tried the skip key which is way too slow. Is there a feature in excel that would allow me to list the wanted columns and allow me to delete the columns that are unneeded?

I assume they are interspersed among the columns you wish to keep? You have not given any criteria to sort them out (e.g. all dates, every other column, blank columns, etc)
You can hold the control key down while clicking on each column header and then right click to delete.
You could import data instead of opening the file. That gives you the option of which columns not to import.
Sorry, can't think of any other ways.

Assuming this is a task you perform over and over and that it's always the same columns (e.g. 1, 12, 21, 56 ..) you write a macro and save it to your personal.xls file to delete those columns when you run the macro. Is that what you are looking for?

is this not the same question you posted here?
http://www.excelforum.com/excel-new-...d-columns.html
if you had responded then perhaps other solutions may have been offered
but if you record a macro following steps i pointed out you can use that.

Threads merged.

DOSPANTERA, please take a few minutes to read the Forum Rules about duplicate posts (and in general) before posting again.