how do i type the same text for multiple rows
 

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

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

how do i type the same text for multiple rows
 

--Select the cell range
--Keeping the selection enter the data into the active cell.
--Press Ctrl+Enter instead of just enter

If this post helps click Yes
---------------
Jacob Skaria


"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

how do i type the same text for multiple rows
 

Yet another way which I like most

--Fill down:Enter data to a cell. Select the cell. Extend selection down.
Press Ctrl+D

--Fill right:Enter data to a cell. Select the cell. Extend selection to
right Press Ctrl+R


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

--Select the cell range
--Keeping the selection enter the data into the active cell.
--Press Ctrl+Enter instead of just enter

If this post helps click Yes
---------------
Jacob Skaria


"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

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