lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much.
[TABLE="class: outer_border, width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]red[/TD]
[/TR]
[TR]
[TD]black[/TD]
[/TR]
[TR]
[TD]red[/TD]
[/TR]
[TR]
[TD]white[/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]brown[/TD]
[/TR]
[TR]
[TD]green[/TD]
[/TR]
[TR]
[TD]green[/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]white[/TD]
[/TR]
[TR]
[TD]pink[/TD]
[/TR]
[TR]
[TD]blue[/TD]
[/TR]
</tbody>[/TABLE]
I have a column like the one below. I highlighted the cells and then dragged the autofill down. I got all cells value as = "red". Why is that? is it because they are color words. Thank you so much.
[TABLE="class: outer_border, width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]red[/TD]
[/TR]
[TR]
[TD]black[/TD]
[/TR]
[TR]
[TD]red[/TD]
[/TR]
[TR]
[TD]white[/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]brown[/TD]
[/TR]
[TR]
[TD]green[/TD]
[/TR]
[TR]
[TD]green[/TD]
[/TR]
[TR]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]white[/TD]
[/TR]
[TR]
[TD]pink[/TD]
[/TR]
[TR]
[TD]blue[/TD]
[/TR]
</tbody>[/TABLE]