Entering same data into multiple cells

G

Gary H

Hello! I am using Excel 2003, and I have a bunch of cells where I would like
the same data entered into them.

Instead of going through and pressing 0 then return two hundred times, is
there a way I can just highlight all of the cells where I want them to
contain a 0, and then do it in one or very few keystrokes? All of the cells
are not in the same row or column.

Thanks.

Gary
 
T

Trevor Shuttleworth

Gary

provided the cells are in a contiguous block, select all the cells, type 0
and then press Ctrl-Shift-Enter

Regards

Trevor
 
D

Duke Carey

Select all the cells where you want to enter the same data, type the data
into one of the cells, AND THEN press Ctrl-Enter to fill them all with the
same thing
 
G

Gary H

Worked perfect. Thank you!

Gary

Duke Carey said:
Select all the cells where you want to enter the same data, type the data
into one of the cells, AND THEN press Ctrl-Enter to fill them all with the
same thing
Click to expand...
 
Top