View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default how do i type the same text for multiple rows

Select the range A1:A7

Type whatever it is you want to type *but* instead of hitting Enter like you
normally would hold down the CTRL key then hit Enter.

--
Biff
Microsoft Excel MVP


"troubled" wrote in message
...
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