Excel 2007 : Working With Existing Lists

I am working with existing list, I need to be able to delete columns to condense some unnecessary data. Because of the nature of the sheet, if I delete a column, it will delete multiple columns.

It is set up like this:

Columns 2-9 will represent a given sliver of data for a particular item. Rows 2-10 are full of individual cells of data, while row 1 is the header for that particular group of data. This goes across my workbook, 2-9, 10-17 ect. I need to delete 4-9, 12-17 ect, but because of the header it will delete the whole section, example, if I try to delete 4-9, it will delete 2-9.

I know I can do this, because when I work on my office PC with 2003, I can load up the workbook and delete away. When I try to do it on my home Mac, it won't let me, I must be missing a step.

I do not want to transpose the data, I just want to loose a couple of columns.

Any suggestions would be great.

Thanks, you just made my life so much easier!