View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default How do I copy a number to an entire column

one way, select the range, enter the number and press control-enter.

--

Gary Keramidas
Excel 2003


"Kerri" wrote in message
...
Say I want to copy the number one to 4,000 plus lines, how do I do that
quickly?