+ Reply to Thread
Results 1 to 4 of 4

Removing empty cells and shifting cells with contents to the left

  1. #1
    Registered User
    Join Date
    04-30-2012
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    88

    Removing empty cells and shifting cells with contents to the left

    Hi there

    I have a worksheet containing c5500 rows. I need to remove the empty cells from Column E onwards, so that there are no blank cells between full cells in the rows.

    As an example, F2:BA2 are all blank cells, then BB2:BC2 have data.

    I need to remove F2:BA2 so that BB2:BC2 sit F2:G2.

    At the moment it is a very manual process, any solutions to do this much more quickly would be greatly appreciated!

    Book7.xlsx

    thanks

    Steve
    Last edited by Steve_123; 09-21-2015 at 05:46 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Removing empty cells and shifting cells with contents to the left

    You have to select the whole data then CTRL G and then go to special then check mark on blank. This step will select the whole blank cell in given selection now go to Home and delete them in one command simply
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    04-30-2012
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    88

    Re: Removing empty cells and shifting cells with contents to the left

    amazing! Thank you!

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Removing empty cells and shifting cells with contents to the left

    Glad it helps you pls mark as it solved.

+ 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. Delete empty cells, and shift left
    By kiboodez in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2014, 07:53 AM
  2. Delete empty cells and shifting to the left.
    By GMusgrove in forum Excel General
    Replies: 3
    Last Post: 03-04-2014, 09:19 PM
  3. Conditional Shifting Cells to the Left Macros
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2011, 07:25 AM
  4. Deleting cells and shifting them left
    By knitterkuba in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2010, 05:12 PM
  5. Counting empty cells to the left
    By Befuddled in forum Excel General
    Replies: 13
    Last Post: 09-24-2009, 12:27 AM
  6. Removing empty cells
    By crania in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-06-2007, 08:47 PM
  7. [SOLVED] Removing '0's' in cells-What is the easiest way to empty these cells?
    By pewe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2005, 03:05 PM
  8. Replies: 6
    Last Post: 04-21-2005, 01:06 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