| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
make labels 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! |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
make labels in excel
I'd use a formula. Put this in A1 and copy down and to the right:
="Full " & TEXT((COLUMN()-1)*50+ROW(),"0000") Matthew Louden wrote: 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! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make labels from an Excel spreadsheet?? | Excel Worksheet Functions | |||
| HOW DO I MAKE ADDRESS LABELS OUT OF LIST IN EXCEL DOC? | Excel Discussion (Misc queries) | |||
| Is there any way to make labels from an excel spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I make labels from excel spreedsheet? | Excel Worksheet Functions | |||
| How do I make mailing labels from an excel document? | Setting up and Configuration of Excel | |||
Hybrid Mode
