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.
- In an adjoining segment, utilize the =ISEVEN() or =ISODD() work, joined with a ROW() work that references any cell in that column.
- 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 : www.office.com/setup
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 office.com/setup.