Entering same data into multiple cells

[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

 

[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

 

[Guest]

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

 

[Gary H]

Worked perfect. Thank you!

Gary

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