Thread: How to get from 1 - 50
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How to get from 1 - 50
One way, enter in A1: 1, then right-click on A1's fill handle*, drag down as
far as required. Upon release, choose Fill Series.
*the black square at the bottom right corner of A1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JayKimball" wrote:
How can I get a collum to go from 1-50 with out typing 1 then 2 then 3 so on
and so forth in every row?
Reply With QuoteReply With Quote