Hi,

Depending on how your data is layed out this could be a real problem, but
lets assume that when all columns that are blank are blank in all the cells
in the column except the name at the top.

1. Select all the data 150x200
2. Press F5, Special, Blanks, OK
3. Press Ctrl+- (control minus) and choose Shift cells left.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Barry Lennox" wrote:

I have range say c150:x200. Row 150 contains names, and the lower rows, data.
How do I delete the columns in the range without data (deleting also the
name). The deletion is to apply to the range not the whole spreadsheet.