how do i type the same text for multiple rows

[troubled]

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

 

[T. Valko]

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.

 

[Jacob Skaria]

--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

 

[YESHWANT]

hi troubled,

1. select a1:a7, click on edit, fill and down or
2. type the desired date in a1, select a2, type "=a1" (without
quotes) and drag down to a7

 

[Jacob Skaria]

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

 

[JP]

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