#1
|
|||
|
|||
Copying data from sheet with deleted columns creates blanks
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! |
#2
|
||||
|
||||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing columns within sheet | shabbaranks | Excel | 2 | 09-11-2012 05:03 AM |
Exporting workbook specific sheet columns on exit | shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Copying data from one cell to another automatically | mrphilk | Excel | 4 | 06-10-2010 11:52 PM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |