Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 05:18 PM.


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