Thread: How do I number a table with 300 row (in a different column)
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default How do I number a table with 300 row (in a different column)
Hi

I think by far the simplest method is to type 1 in cell A1.
Click and drag the fill handle down as far as you want
then hold down ctrl, let go of the left click, let go ctrl.
Et Voila!!

HTH
Martin


Reply With QuoteReply With Quote