enter same text into many different cells

C

Christmas Ape

How can I enter an "x" into many different cells on a
worksheet? For example, I may want one in A7, A23, A44,
B3, B8, B12, C1, . . .

Is there a way to just enter those cell names and have
an "x" go there instead of scrolling all around the
worksheet? Thanks!
 
P

Peo Sjoblom

One way,
put "x" in an empty cell, copy the cell, press F5 and type in the cell
addresses delimited
by a comma, press enter or click OK. Press Ctrl + V to paste in the "x"
 
E

Earl Kiosterud

Ape,

Another is to select the cells first (Use the Ctrl key as you click
additional cells). Then enter your stuff into the active (white) cell.
Press Ctrl-Enter. A miracle.

Might be quicker to enter it into the first cell. Reselect. Copy. Select
other cells one at a time (or more with Ctrl or Shift), then do Paste
(Ctrl-V) at each one. Click, boom. Click, boom.
 
Top