F*******n
发帖数: 89 | 1 I want to fill a very big column with same context (e.g., "shopping") in eac
h cell of it. Instead of manually input one by one, what is the easier way t
o do that?
Moreover, what if I want to fill the column with incremental numbers( e.g.,
from 1 to N, assuming N rows)?
thanks. | c**r
发帖数: 10001 | 2 1. input 'shopping' to the first cell, select this cell, ctrl+c,
select the cells you want to have this text, ctrl+v
2. input sth like '=row(A1)' in the first cell, if this cell is in column A,
select this cell, ctrl+c, select the cells you want to have number, ctrl+v
eac
t
【在 F*******n 的大作中提到】
: I want to fill a very big column with same context (e.g., "shopping") in eac
: h cell of it. Instead of manually input one by one, what is the easier way t
: o do that?
: Moreover, what if I want to fill the column with incremental numbers( e.g.,
: from 1 to N, assuming N rows)?
: thanks.
| F*******n
发帖数: 89 | 3 thank you so much.
Very useful and helpful.
A,
【在 c**r 的大作中提到】
: 1. input 'shopping' to the first cell, select this cell, ctrl+c,
: select the cells you want to have this text, ctrl+v
: 2. input sth like '=row(A1)' in the first cell, if this cell is in column A,
: select this cell, ctrl+c, select the cells you want to have number, ctrl+v
:
: eac
: t
|
|
