Copying data from sheet with deleted columns creates blanks

[ZGreyArea]

I'm wanting to copy data from a sheet with deleted columns (ie. goes straight from G to I, K to M etc.) When I copy the list of values I get blanks where those missing columns would have been, which I don't want. How do I get rid of them or prevent this happening? I'm using Excel 2010.

Thanks in advance, I'd really appreciate any help!

[BobBridges]

ZGrey, I'm pretty sure that if your spreadsheet columns "go straight from G to I" then those columns aren't deleted, they're only hidden. Hidden columns have no width, but they're still there and they can still have data in them—although they may not in your case, if when you copy the worksheet all you see is blanks.

In Excel 2010 you can unhide columns using File, Format, Hide & Unhide; or you can just select columns G through I, then set their column width to something greater than 0 and voilà!, they'll be visible. Maybe once you've unhidden them you'll decide you really can delete them.