Why does the first cell of my selection override instead of alternate?

unsolved

Hello again friends, I need help again.

I'm trying to do some alternate naming of rows, so for instance in a1 I have Tim and a2 I have Sally. When I select and pull it down I see the tool tip alternating the names (good) but when I release, Tim covers everything (Bad, Tim is not that hardworking). Do I have a setting I need to change?

Edit: I found a workaround, it was a filtered list, so copy and pasting it as a new list worked. But I'd like to know if there's a way to keep the filter and do this.

Posted Aug 27, 2020, 3:20 AM UTC · edited

13
AutoModeratorMOD•

u/boxedmachine - please read this comment in its entirety.

Once your problem is solved, please reply to the answer(s) saying Solution Verified to close the thread.

Please ensure you have read the rules -- particularly 1 and 2 -- in order to ensure your post is not removed.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1
boxedmachineOP•

I found a workaround, it was a filtered list, so copy and pasting it as a new list worked. But I'd like to know if there's a way to keep the filter and do this.

1
[deleted]•

[deleted]

1
boxedmachineOP•

Okay, thanks updated

1