Thread: How to set the entire selection to a specific value without using VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Koye Li[_2_] Koye Li[_2_] is offline
external usenet poster
  
Posts: 5
Default How to set the entire selection to a specific value without using VBA
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
Reply With QuoteReply With Quote