Entering same data into multiple cells
 

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

Gary

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

Regards

Trevor


"Gary H" wrote in message
. ..
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

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" wrote:

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

Worked perfect. Thank you!

Gary

"Duke Carey" wrote in message
...
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" wrote:

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