+ Reply to Thread
Results 1 to 2 of 2

go through a range and delete, shift cells left if contain no data.

  1. #1
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    go through a range and delete, shift cells left if contain no data.

    Hi,

    So i have data that gets seperated into different cells and what i need is for all the data to line up from left to right with no empty cells in between.. so basically shift delete on each cell and shift the data left.

    So i thought i know, ill simply f5, select the blanks, delete and shift left... however that option doesnt come up.. it simple says delete row?

    What is the best way to select all the blanks in a range and delete them and have the cells that contain data move to the left so all data is next to each other.


    Hope this makes sense!

  2. #2
    Forum Contributor
    Join Date
    06-17-2013
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    247

    Re: go through a range and delete, shift cells left if contain no data.

    Nevermind, im stupid, i had the data filtered.. lol

+ 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. [SOLVED] If criteria met: delete cell and shift to the left but shift only over a certain range
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 07:44 AM
  3. [SOLVED] Conditional Delete Cells and shift to the left
    By markos97 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-19-2013, 12:32 PM
  4. Delete cells if blank, shift left until data found
    By wishkey in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2013, 08:22 PM
  5. delete blank cells and shift data left
    By rhudgins in forum Excel General
    Replies: 7
    Last Post: 07-30-2010, 11:16 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