Separate Odd And Even Columns In Excel
Exceed expectations’ sifting highlight is great and the new table-separating highlight offers significantly more. Be that as it may, there’s one thing neither can do: neither can channel an informational index by Separate Odd And Even Columns. Luckily, it’s anything but difficult to do. Essentially add an additional section to the informational index as takes after and channel by the outcomes:
- 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 drop-down and pick False or True. False will show odd columns; True will show even lines.