Excel Spreadsheet For Specimen Labels

An area for archived forum posts
Post Reply
SteveMcBill
Posts: 809
Joined: Thu Jul 31, 2008 9:15 am
Location: Runcorn, Cheshire
Contact:

Excel Spreadsheet For Specimen Labels

Post by SteveMcBill »

Excel Spreadsheet For Specimen Labels:

Below is a downloadable Excel spreadsheet for producing specimen labels for insects of other invertebrates.

Data labels are used for pinned insects. This Excel file is a conveniently pre-formatted template for printing a full page of insect data labels on standard letter-size paper (24 lb. stock or higher recommended). Each label has a border so that you can easily cut them out of the page. The font used is very small: 7 point; about as small as you can get and still be legible (Laser printer recommended).

There are four tabs in the Excel workbook: the first tab is for 161 three-line labels and the second tab is for 108 four-line labels. One label with sample data will be included in each tab. Simply enter your own data in each cell and then copy and paste the cell groups to make as many of each label as you need - or clear all cell contents to print blank labels. Cells are pre-formatted for optimum results. You can, of course, customize the cells with your own fonts, etc. However, if you increase the font size much higher than 7 pts. or if you change the page setup variables you may get unpredictable results on the printed page.

The third tab is the same as the first but allows for auto fill of the contents by you filling in the top-left area which is highlighted in yellow. In a similar fashion the fourth tab is similar to the second but allows for auto-fill of the rest of the sheet once you complete the yellow label in the top-left corner.

Steve

Attachments
Insect Data Labels.xls
Insect Data Labels Spreadsheet
(123 KiB) Downloaded 1359 times
Post Reply