Great video. When you're coloring random cells the same color, I think you can actually color the first one, then click on the others and press Ctrl+Y and it will color those cells too, so you don't need to keep going up to the menu. Although it's more visual to viewers if you do keep going back to the menu.
@@DanaLeeds Or you could just Copy/Paste a colored cell into another (or multiple) with Ctrl+C and Ctrl+V. You can paste into multiple cells at once, copy one with Ctrl+C and then highlight all the ones you want to color, then paste with Ctrl+V. Or, if the cells are adjacent, drag the little square in the lower right corner of a colored cell to fill the adjacent cells with the same content (=color in this case). I wouldn't trust the Ctrl+Y command that was previously mentioned for this purpose, since I read that it is used to redo the last action that was undone. Not quite what we are looking for here. (But I may have misunderstood how Ctrl+Y works, I apologize if I have.)
Is there a way to use this when my adopted so only has on his father's side 6 matches that fall between 90 and 400 cm? His father is unknown. I don't need to know his mother's side because she is our daughter. Is there any way to use this under these circumstances?
@@susanclay6959 Is this on Ancestry? I would check the 6 matches and see if they all match each other, or if you form 2 (or more) groups. Then if there are higher matches, add those. And add in smaller matches as needed. Hope that helps!
Great video. When you're coloring random cells the same color, I think you can actually color the first one, then click on the others and press Ctrl+Y and it will color those cells too, so you don't need to keep going up to the menu. Although it's more visual to viewers if you do keep going back to the menu.
Wow! I had no idea. That's a great time saver. Thanks!! 💞
It's not just for coloring, it's basically a "repeat what I just did" command.
@@DanaLeeds Or you could just Copy/Paste a colored cell into another (or multiple) with Ctrl+C and Ctrl+V. You can paste into multiple cells at once, copy one with Ctrl+C and then highlight all the ones you want to color, then paste with Ctrl+V. Or, if the cells are adjacent, drag the little square in the lower right corner of a colored cell to fill the adjacent cells with the same content (=color in this case). I wouldn't trust the Ctrl+Y command that was previously mentioned for this purpose, since I read that it is used to redo the last action that was undone. Not quite what we are looking for here. (But I may have misunderstood how Ctrl+Y works, I apologize if I have.)
@@christinablanck7486, Thanks! I should have known to try Ctrl+C & Ctrl+V but didn't think of it. 🙂 I appreciate the tips!
Thanks for this - so helpful. Tips for using Excel were much appreciated
@@kathleenkelley1299, Thank you for sharing! And you’re welcome. 😊
Thank you, Dana
@@kathrynludrick4821, you’re welcome! And thanks for leaving a comment! It’s always appreciated. 😊
Is there a way to use this when my adopted so only has on his father's side 6 matches that fall between 90 and 400 cm?
His father is unknown. I don't need to know his mother's side because she is our daughter.
Is there any way to use this under these circumstances?
@@susanclay6959 Is this on Ancestry? I would check the 6 matches and see if they all match each other, or if you form 2 (or more) groups. Then if there are higher matches, add those. And add in smaller matches as needed. Hope that helps!
Ok thanks. That's what I thought.
I have trouble differentiating colors so I used letters and symbols. XXXXX --- ?????? &&&&&
GREAT idea! Thanks for sharing! 🙂