Hi,

Let say I have a selected range (A1:A100) and I would like set every cell in the range to be 100. Instead of doing someting in VBA like

Selection.value = "100"

Is there a way that I can do this using exel? Some sort of keyboard shortcut would be nice.

Thanks,

Koye

With your selection, type 100 and hit CTRL+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"Koye Li" wrote in message
...
Hi,

Let say I have a selected range (A1:A100) and I would like set every cell
in the range to be 100. Instead of doing someting in VBA like

Selection.value = "100"

Is there a way that I can do this using exel? Some sort of keyboard
shortcut would be nice.

Thanks,

Koye

Type 100 in the top field and hit cntrl-D (fill down.)

"Koye Li" wrote:

Hi,

Let say I have a selected range (A1:A100) and I would like set every cell in the range to be 100. Instead of doing someting in VBA like

Selection.value = "100"

Is there a way that I can do this using exel? Some sort of keyboard shortcut would be nice.

Thanks,

Koye