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