Results 1 to 4 of 4

Aggregate data / remove empty columns

Threaded View

  1. 04-16-2014, 05:54 PM #2
    Faraz.Ahmed
    Faraz.Ahmed is offline
    Registered User
    Join Date
    04-16-2014
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Aggregate data / remove empty columns

    1. Select the whole range of data.
    2. Press Ctrl+G
    3. Press "Special" button
    4. Select "Blanks" and press OK
    5. Press Ctrl+"-" (Ctrl + minus)
    6. Select 1st option that is "Shift cells left" and press OK


    OR

    1. Select the whole range of data.
    2. On Home Tab in Editing group click on the small arrow below Find & Select.
    3. Select Go to Special...
    4. Select "Blanks" and press OK
    5. Press Ctrl+"-" (Ctrl + minus)
    6. Select 1st option that is "Shift cells left" and press OK
    Last edited by Faraz.Ahmed; 04-16-2014 at 06:06 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove whitespace from empty (non-existent) columns
    By throwaway992 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2013, 12:17 AM
  2. Aggregate data in a range of columns to remove blank cells
    By arbgd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 04:11 PM
  3. [SOLVED] Remove Empty Rows ,Columns & Sort
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2013, 03:40 AM
  4. remove empty spaces in data
    By kisboros in forum Excel General
    Replies: 8
    Last Post: 02-13-2013, 12:06 AM
  5. Help remove the empty columns or rows
    By SimonLee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2011, 11:20 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1