+ Reply to Thread
Results 1 to 2 of 2

Deleting Blank Cells Wholesale?

  1. #1
    Trey
    Guest

    Deleting Blank Cells Wholesale?

    Hi --

    I have a large excel spreadsheet with over 1,000 rows of data with blank
    cells scattered in all different columns. I need a way to bring all data over
    to the left and stack up from left to right within eachrow. In other words, I
    need an easy, efficient way to delete all of the blank cells in the range so
    that all remaining populated cells will shift to the left. Any advice?

    Thanks in advance!!

  2. #2
    Ken Wright
    Guest

    Re: Deleting Blank Cells Wholesale?

    Select whole area, do Edit / Go to / Special / Blanks, then hit Edit /
    Delete / Shift cells left.

    Regards
    Ken..............

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ------------------------------*------------------------------*----------------
    It's easier to beg forgiveness than ask permission :-)
    ------------------------------*------------------------------*----------------

    "Trey" <Trey@discussions.microsoft.com> wrote in message
    news:6DB08F81-85AF-455C-8AD1-6D1DE53F904D@microsoft.com...
    > Hi --
    >
    > I have a large excel spreadsheet with over 1,000 rows of data with blank
    > cells scattered in all different columns. I need a way to bring all data
    > over
    > to the left and stack up from left to right within eachrow. In other
    > words, I
    > need an easy, efficient way to delete all of the blank cells in the range
    > so
    > that all remaining populated cells will shift to the left. Any advice?
    >
    > Thanks in advance!!




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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