Using a prepared Microsoft Excel file is the fastest way to clean up your electrical panel when the standard factory labels are missing or lost. Precise adherence to the dimensions of the cells in the program allows you to immediately obtain markings ready for gluing, eliminating the need for subsequent trimming or manual rewriting of names by hand. A correctly configured template for signing machines in a shield in Excel ensures that each cell fits perfectly on modular equipment with a width of 18 mm or a multiple of it.
⚠️ Attention: Before you start printing, be sure to check the scaling settings in the printer driver so that the actual size of the labels matches the physical dimensions of the modules.
A professional approach to marking requires not just printing text, but creating a durable and readable notation system. Electrical safety directly depends on how quickly and correctly you or other users can identify the required machine in an emergency. Digital tools such as spreadsheet processors make it easy to edit the consumer list when wiring changes.
Creating quality markings begins with understanding what data should be displayed on the front panel of the shield. Circuit breakers from various manufacturers, whether ABB, Legrand or IEK, have a standard module width, which simplifies the unification of templates. However, the height and overall design may vary, requiring customization of document margins.
Preparing Page and Grid Settings
The first step in creating an effective template is to fine-tune the size of the cells, since this determines the final fit of the sticker to the machine. A standard single-module machine has a width of 18 mm, so the cell width in Excel should be set to this value or in terms of points (about 68 points for 18 mm, but it’s better to focus on millimeters in the page settings). The line height is usually selected experimentally, but the optimal value is considered to be in the range from 10 to 15 mm for comfortable reading of the text.
For ease of use, it is recommended to turn on the grid display and set the page layout mode to see the actual boundaries of the paper sheets. Formatting cells should be done with the text centered horizontally and vertically, which will ensure an aesthetic appearance of the finished sticker. The use of bold font and black on a white background is the standard to ensure maximum contrast.
- 📏 Set the column width to exactly 18 mm for single-module machines or 36 mm for two-module machines.
- 📐 Keep page margins as low as 5mm to make the most of your page space.
- 🔤 Choose a sans-serif font, such as Arial or Roboto, at 10-12 pt for better readability.
- 🖨️ Turn on print preview to check that text fits within cell boundaries before final printing.
It is important to consider that printers may have unprintable areas, so the outermost cells should be made with a slight indentation from the edge of the sheet. A critically important parameter is the scaling when printing: it must be strictly 100%, otherwise the dimensions will be lost and the stickers will not fit in a row. Checking the printed test sheet with a ruler is a mandatory procedure before mass printing.
Data structuring and consumer grouping
Logical grouping of electricity consumers greatly simplifies the operation of the electrical panel and troubleshooting. Instead of a chaotic listing of rooms or devices, it is advisable to divide the loads according to functionality: lighting, sockets, power equipment, climate systems. This structure allows you to quickly disconnect entire groups of consumers during repair work or in the event of an emergency.
In an Excel table, you can reserve a separate block of cells for each group, visually separating them with blank lines or borders. Group markings should be short but understandable, for example, “Kitchen Lights” or “Living Room Sockets”. Avoid using complex abbreviations that may not be clear to other family members or future electricians.
For complex objects, such as private houses or offices, it is useful to maintain a parallel list in adjacent columns indicating the rating of the machine and the type of RCD. This creates a complete shield diagram, which is always at hand. If the wiring configuration changes, updating such a digital ledger takes just minutes, as opposed to manually copying out paper diagrams.
| Consumer group | Machine denomination | RCD type | Note |
|---|---|---|---|
| Lighting 1st floor | 6 A (C6) | - | LED lamps |
| Kitchen sockets | 16 A (C16) | 30 mA (AC) | Dishwasher |
| Air conditioning | 10 A (C10) | 30 mA (A) | Split system living room |
| Introductory machine | 25 A (C25) | - | General line protection |
| Warm floor | 10 A (C10) | 30 mA (A) | Bathroom |
Using color coding in Excel helps visually highlight critical lines, such as power to a server room or refrigerator. However, when printing stickers, it's best to stick to a monochrome style unless you have access to a color printer with durable ink that won't fade over time.
Technical requirements for materials and printing
Choosing the right material for printing stickers is a guarantee of their durability and presentable appearance. Ordinary office paper will quickly become unusable due to dust, moisture and mechanical stress, so using self-adhesive paper or film is a prerequisite. The optimal solution is a matte film, which does not leave fingerprints and glare from light does not interfere with reading.
⚠️ Attention: Glossy film can glare in bright light, making it difficult to read inscriptions, so a matte coating is preferable for electrical panels.
If you are using a laser printer, make sure the material is heat-resistant, as the printer's oven heats the paper to high temperatures. Inkjet printing requires the use of special photo papers or films with an appropriate coating to absorb ink, otherwise the text may float at the slightest contact with moisture. Lamination Covering finished stickers with a transparent film will significantly increase their service life and protect them from fading.
Print media comparison
Sticker paper is cheap, but doesn't last long. PVC film is resistant to moisture and abrasion. Polyester - maximum strength and chemical resistance, but requires a special printer.
The density of the material also plays a role: a film that is too thin may jam in the printer, and a film that is too thick may not adhere well to the rough surface of modular machines. Recommended density is in the range of 120-160 g/m² for paper and 80-100 microns for film. Before printing the entire series of labels, make a test copy on the selected material.
The process of creating and formatting a template
Directly creating a template in Excel begins with clearing the sheet of unnecessary elements and setting the basic parameters. It is recommended to use the "View" -> "Page Layout" function to immediately see how the content will be distributed on A4 sheets. This avoids a situation where one row of labels is transferred to a new sheet of material.
To automate the process, you can use formulas to number rows or copy duplicate values. Conditional Formatting will help highlight cells where the text goes beyond the boundaries, signaling the need to reduce the font or shorten the title. This is especially true for long consumer titles.
☑️ Check before printing
Save the finished file as an Excel template (.xltx) so that in the future you do not have to configure the settings again, but only change the text content. This will save time when servicing multiple sites or when regularly updating markings on one site. Backup template on cloud storage will protect against data loss in the event of equipment failure.
Installation of stickers and final inspection
The process of adding signatures requires care and compliance with safety precautions. Before starting work de-energizing the shield is mandatory, even if you are working only with the front panel, to eliminate the risk of accidentally touching live parts when removing the plastrons. Clean the surface of the machines from dust and degrease with an alcohol wipe for better adhesion of the glue.
Apply decals starting from one edge, gradually smoothing them with a squeegee or plastic card to avoid the formation of air bubbles. If film is used, it can stretch to allow positioning to be adjusted, but paper stickers require precision the first time. Aligning to the bottom or top edge of the modules will create a cleaner look.
- 🧹 Degrease the surface of the machines before applying the sticker for maximum adhesion.
- ✂️ Use a utility knife to precisely trim excess margins between stickers.
- 👀 Check the readability of all inscriptions in different lighting conditions after installation.
- 🔒 Make sure that the stickers do not interfere with the movement of control levers and switches.
After installing all the signatures, it is recommended to take a photo of the assembled board and save the photo along with a digital version of the diagram. This will help in the future to quickly restore the marking if it is damaged or lost. Updating the scheme with any changes in wiring - a rule of good manners for any property owner.
Common mistakes when marking electrical panels
One of the most common mistakes is using handwritten lettering that fades over time, gets erased, or is simply hard to read. Printed text, created in Excel, does not have these shortcomings and looks professional. In addition, everyone’s handwriting is different, and what is clear to the author may be a mystery to the electrician who comes to the call.
⚠️ Attention: Never use tape to secure paper signatures as it turns yellow, dries and falls off after a short time, leaving a sticky layer.
Another mistake is excessive detail, when they try to fit the cable number, core cross-section, route length and installer’s name on the sticker. Marking of machines should carry only a functional load: indicate what exactly will turn off when the lever is moved. Technical details should be included in the object passport or diagram stored in the archive.
The main principle of marking is maximum simplicity and readability for anyone, not just an electrician.
Ignoring the safety factor of the material also leads to rapid wear of the markings. Cheap paper can simply crumble into dust after a couple of years, especially if the shield is located in an unheated room or garage. The use of quality materials pays off in the absence of the need to redo the work every few years.
FAQ: Frequently asked questions
How to convert millimeters to Excel points to fine-tune cell width?
In Excel, 1 point (pt) is approximately equal to 0.35 mm. To obtain a width of 18 mm, you need to set the column width to approximately 51 points. However, it would be more accurate to switch to page layout mode and set the width directly in millimeters through the "Format Cells" -> "Alignment" menu or column properties.
Can I use regular tape to protect paper stickers?
It is strictly not recommended to use regular office tape. Over time, it becomes cloudy, turns yellow, peels off at the edges and leaves traces of glue that are difficult to remove. To protect paper printouts, it is better to use special transparent films for lamination or directly print on self-adhesive film.
What should I do if my printer won't pick up thick label paper?
If your printer isn't feeding thick media, try feeding through the bypass tray (if you have one), which has a straighter paper path. You can also try printing on sheets of lower density and gluing them onto a thicker base, or use an inkjet printer, which is less demanding on media thickness.
Do I need to indicate the machine's nominal value on the sticker?
It is usually not necessary to indicate the denomination (for example, C16) on the sticker itself, which is affixed to the machine, since this information is stamped on the device body itself. On the sticker it is enough to indicate the name of the consumer group (for example, “Kitchen outlets”). The denomination can be indicated in the general diagram of the shield.
How to update a template if a new machine has been added?
In Excel, this is done simply: open the saved template file, insert a new line in the right place, enter the name of the new consumer and save the file. Then simply reprint the sheet. This is the main advantage of a digital template over handwritten versions or static images.