Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2013, 09:22 PM
ZGreyArea ZGreyArea is offline Copying data from sheet with deleted columns creates blanks Windows 7 64bit Copying data from sheet with deleted columns creates blanks Office 2010 32bit
Novice
Copying data from sheet with deleted columns creates blanks
 
Join Date: Nov 2013
Posts: 1
ZGreyArea is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 11-20-2013, 10:12 AM
BobBridges's Avatar
BobBridges BobBridges is offline Copying data from sheet with deleted columns creates blanks Windows 7 64bit Copying data from sheet with deleted columns creates blanks Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing columns within sheet shabbaranks Excel 2 09-11-2012 05:03 AM
Copying data from sheet with deleted columns creates blanks 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 sheet with deleted columns creates blanks Copying data from one cell to another automatically mrphilk Excel 4 06-10-2010 11:52 PM
Copying data from sheet with deleted columns creates blanks Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft