+ Reply to Thread
Results 1 to 2 of 2

insert alternate blank columns

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    46

    insert alternate blank columns

    Hi All

    I have data in 57 columns. Is there any way I can insert a blank column after each filled column. I am tired of doing this manually.

    Thanks

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: insert alternate blank columns

    Are you talking about formatting or data?

    If you want every second column filled with colour, select the area that you want formatted then in Condition Formatting, New, Use Formula.... Enter this and choose the formatting that you want

    This will start the colour in the first column:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This will start the colour in the second column:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Insert 50 blank columns inbetween
    By weidlh46 in forum Excel General
    Replies: 3
    Last Post: 12-30-2013, 03:06 PM
  2. Formula insert in blank columns
    By snorris2001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2012, 07:40 PM
  3. [SOLVED] HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST?
    By Phil A. in forum Excel General
    Replies: 2
    Last Post: 04-19-2005, 12:06 PM
  4. Insert a blank Column Every 9 Columns
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2005, 01:06 PM
  5. Insert Blank Column every 9 Columns
    By Nigel Bennett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 01:06 AM

Tags for this Thread

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