– Resistor Drawer Labels A Better Way – Jim Larsen, AL7FS 5.2.2011 I recently became frustrated with the labels on my drawers of resistors. They are in the garage and the lighting is not so good. Also, the writing on each label was old and very hard to read in the reduced lighting. It was time to correct the problem. I created a spreadsheet with the values I required for my collection of resistors. I color coded the drawer labels based on the third color band on the resistors. This really helps when sorting resistors into the drawers. The spreadsheet can be found at Remember, if you cannot read .xlsx files, there is a free add-on program you can add to your older version of Microsoft Office to enable you to use the newer files. Just go to This spreadsheet was set up to print on an old UPS label that I still had around the house. The UPS label is actually two labels on one page and thus I added in the blank row in the middle. I suspect UPS still has labels like this available. They were free when I requested them. I printed out the labels and used an inexpensive paper cutter to make the long cuts. When I was done with step one, I had 20 strips of labels with three labels on each strip. They were easy to work with in this format and I just took them out to the garage and used a scissors for the tiny vertical cuts.
Resistor Drawer Labels – A Better Way Jim Larsen, AL7FS – 5.2.2011 I recently became frustrated with the labels on my drawers of resistors. They are in the garage and the lighting is not so good. Also, the writing on each label was old and very hard to read in the reduced lighting. It was time to correct the problem. I created a spreadsheet with the values I required for my collection of resistors. I color coded the drawer labels based on the third color band on the resistors. This really helps when sorting resistors into the drawers. The spreadsheet can be found at Remember, if you cannot read .xlsx files, there is a free add-on program you can add to your older version of Microsoft Office to enable you to use the newer files. Just go to This spreadsheet was set up to print on an old UPS label that I still had around the house. The UPS label is actually two labels on one page and thus I added in the blank row in the middle. I suspect UPS still has labels like this available. They were free when I requested them. I printed out the labels and used an inexpensive paper cutter to make the long cuts. When I was done with step one, I had 20 strips of labels with three labels on each strip. They were easy to work with in this format and I just took them out to the garage and used a scissors for the tiny vertical cuts.
ResistorDrawerLabelsABetterWayAL7FS.docx