View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default how do i type the same text for multiple rows

How about

1) Select cell A8
2) Type =A1 and press enter

Repeat steps 1-2 for cells A9 through A14 (increase =A1 to =A2, and so
on)

Then enter data into A1:A7, it will be mirrored in cells A8:A14.

Is that what you wanted?

--JP

On Oct 9, 1:39*pm, troubled
wrote:
i want a1:a7 to have exact info and a8:a14 to have the same also.
Is there a way to input identical cells at the same time, or do i have to
copy and paste