View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default For office labels

Thanks, This works perfectly

"David Biddulph" wrote:

If you type M62242 in the first cell, grab the fill handle (little square in
the bottom right hand corner of the cell) and drag down, it'll probably fill
the series.
If not, type M62242 in the first cell, M62243 in the next cell, select the
two cells, grab the fill handle and drag down.
--
David Biddulph

"Bob" wrote in message
...
Sorry, I didn't word my question better. How do I get excel to extend the
numbers of the cells without me having to number each cell one at a time.
Example M62242 for the first cell. Below or beside it M62243 then M62244
on &
on?

"David Biddulph" wrote:

The best way of producing labels is to use Word's mail merge facility
(which
can take its input from an Excel file). Mail merge recognises Avery 5167
as
one of its standard options.
--
David Biddulph

"Bob" wrote in message
...
I have a column of labels to start @ M62242 & increases by 1 [ 80 cells
per
page ( 4 X20 ) ] How do I do it? [ Avery labels 5167 ]