Thread: Numbers Chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Numbers Chart

Top left corner of chart:
=ROW(A1)+10*(COLUMN(A1)-1)
Copy to a 10x10 area.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"C and A Bredt" wrote:

I need a 10x10 chart of numbers 1-100 with the numbers vertical.
I'm sure there is a quickie way to do it.
thanks, CB
--
C and A Bredt