how do i type the same text for multiple rows

  • Thread starter Thread starter troubled
  • Start date Start date
T

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
 
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.
 
--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
 
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
 
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
 
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
 
Back
Top