enter same text into many different cells

  • Thread starter Thread starter Christmas Ape
  • Start date Start date
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!
 
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"
 
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.
 
Back
Top