How to Separate Odd And Even Columns In Excel

Separate Odd And Even Columns In Excel

Now, separating even and odd columns are very simple to do with the help of the below mentioned functions.

  1. In an adjoining segment, utilize the =ISEVEN() or =ISODD() work, joined with a ROW() work that references any cell in that column.
  2. Double tap the cell’s fill handle to duplicate the recipe to the rest of the range.

Next, empower a straightforward channel by choosing any cell in the information go and clicking Filter in the Sort and Filter gather on the Data tab.

Tap the new segment’s channel dropdown and pick False or True. False will show odd columns; True will show even lines.

Blogs :

Garry, he has been making the people aware of the security threats from so long to make the internet a safer place to browse on. His passion is to write about Cybersecurity, Antivirus, malware, social networking, internet, and new media. He does write for Microsoft Office Products at


Leave a Comment

Your email address will not be published. Required fields are marked *