View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Matthew Louden Matthew Louden is offline
external usenet poster
 
Posts: 3
Default make labels (increasing number) in Excel

I want to make labels in the following format using Excel. What I did was
type the first row number (e.g. Full 0051) and then drag the mouse so that
the number will be increasing. But I have to do it in every column, that is
tedious work. Anyone knows faster way to do that? Also, how can I change the
size of each cell consistency?

Full 0001 Full 0051 ... Full 1951
Full 0002 Full 0052
.... ...
Fulll 0050 Full 0100... Full 2000

Thanks!