For office labels
 

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 ]

For office labels
 

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 ]

For office labels
 

Sorry, I didnt 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 ]

For office labels
 

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 ]

For office labels
 

Bob

Enter M62244 in a cell.

Right-click on the fill handle of that cell(lower right corner) and drag down or
across as far as you wish.

Release the button and "Fill Series".


Gord Dibben MS Excel MVP

On Sun, 9 Dec 2007 12:15:01 -0800, Bob wrote:

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 ]

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 ]

For office labels
 

Thank you very much. Both you & David have saved me a lot of time & stress.

Bob

"Gord Dibben" wrote:

Bob

Enter M62244 in a cell.

Right-click on the fill handle of that cell(lower right corner) and drag down or
across as far as you wish.

Release the button and "Fill Series".


Gord Dibben MS Excel MVP

On Sun, 9 Dec 2007 12:15:01 -0800, Bob wrote:

Sorry, I didnt 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 ]