+ Reply to Thread
Results 1 to 3 of 3

Really Delete Blank Empty Columns

  1. #1
    Registered User
    Join Date
    05-26-2013
    Location
    India
    MS-Off Ver
    Office 2010, 2019
    Posts
    79

    Really Delete Blank Empty Columns

    I have data in Columns A:CN. I copied a formula in CN to the last column of the worksheet (ok, not the smartest move). I then deleted the formula from CO to XFD, the last column. When I tried to insert a new column in my data range A:CN, I received a message that it would not move non blank cells off the worksheet. Sure enough Ctrl+End brought me to the last column XFD. I deleted the columns CO to XFD by selecting the entire columns and right clicking on delete and by using the delete sheet button. But Ctrl+End still brings me to XFD and I can't insert a new column. How can really delete these blank empty columns?
    Last edited by WmBarth; 08-26-2015 at 01:22 PM.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Really Delete Blank Empty Columns

    You sure can. You'll need to delete columns CO:XFD, save, close the workbook, and reopen it.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    05-26-2013
    Location
    India
    MS-Off Ver
    Office 2010, 2019
    Posts
    79

    Re: Really Delete Blank Empty Columns

    That works. When in doubt reboot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete empty/blank rows
    By soranz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-14-2015, 01:16 PM
  2. Delete Empty Columns
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2014, 10:05 AM
  3. [SOLVED] Delete Rows after finding first Empty/Blank
    By ptmuldoon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-01-2014, 11:15 AM
  4. Delete Empty Rows and empty columns from the word table
    By mvneema in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 10:51 AM
  5. VBA to delete empty columns that have Heading by other cells are Blank
    By dhiresh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 07:14 AM
  6. [SOLVED] VBA Find last row and column that contain data and delete all blank rows and blank columns
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2012, 01:07 PM
  7. [SOLVED] Help with a macro to delete empty (but not blank) cells OR sort blanks to the bottom
    By Cyali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2012, 09:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1