{"id":7249,"date":"2020-10-30T15:40:27","date_gmt":"2020-10-30T15:40:27","guid":{"rendered":"https:\/\/www.smithcorona.com\/blog\/?p=7249"},"modified":"2023-12-28T16:09:06","modified_gmt":"2023-12-28T16:09:06","slug":"create-a-barcode-in-google-sheets-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/","title":{"rendered":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\"><p><span style=\"font-weight: 400;\">Say you have an online store and are looking for a quick and easy way to create, organize, and print barcode labels for your business. <\/span><\/p>\n<\/div>\n            <div class=\"smith-corona-featured-image\">\n\n                <img src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-create-barcodes-hero-splash.png\" alt=\"\" width=\"760\" height=\"460\" \/>\n\n            <\/div>\n        <div class=\"fusion-text fusion-text-2\"><p><span style=\"font-weight: 400;\">Before purchasing an expensive barcode software, you can try creating your company\u2019s barcodes in a Google Sheets program or Microsoft Excel.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s take a look at how to access these features and use them to your advantage.<\/span><\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-0{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-0 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-0{width:100% !important;order : 0;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-0{width:100% !important;order : 0;}.fusion-builder-column-0 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-1{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1064px) {.fusion-title.fusion-title-1{margin-top:5px!important; margin-right:0px!important;margin-bottom:10px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-1{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"margin-top:5px;margin-right:0px;margin-bottom:10px;margin-left:0px;\"><h2 class=\"title-heading-left\" style=\"margin:0;\"><strong>Google Sheets\u00a0<\/strong><\/h2><\/div><div class=\"fusion-text fusion-text-3\"><p style=\"text-align: left;\"><span style=\"font-weight: 400;\">Below is a step by step look at how to create a barcode in Google Sheets for your online business.<\/span><\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-1{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-1 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-1{width:100% !important;order : 0;}.fusion-builder-column-1 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-2{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-4\"><p><strong>1. Open Google Sheets and start a new spreadsheet<\/strong><\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-2{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-2 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-2{width:100% !important;order : 0;}.fusion-builder-column-2 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-3{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-5\"><p><strong>2. Organize your business information into columns (i.e. product name\/number, code numbers, customer names, barcodes, etc.)<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><img width=\"600\" height=\"349\" title=\"how to barcode 1\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-barcode-1-600x349.png\" alt class=\"img-responsive wp-image-7254\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-barcode-1-200x116.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-barcode-1-400x232.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-barcode-1-600x349.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-barcode-1.png 773w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-3{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-3 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-3{width:100% !important;order : 0;}.fusion-builder-column-3 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-4{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-5 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-6\"><p><strong>3. Add your products into the spreadsheet<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><img width=\"600\" height=\"354\" title=\"how to create barcode 10\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-10-600x354.png\" alt class=\"img-responsive wp-image-7258\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-10-200x118.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-10-400x236.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-10-600x354.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-10.png 775w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-4{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-4 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-4{width:100% !important;order : 0;}.fusion-builder-column-4 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-4{width:100% !important;order : 0;}.fusion-builder-column-4 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-5{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-6 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-5 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-7\"><p><strong>4. Give each product its own unique identification number<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-3 hover-type-none\"><img width=\"600\" height=\"371\" title=\"how to create barcode 2\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-2-600x371.png\" alt class=\"img-responsive wp-image-7262\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-2-200x124.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-2-400x247.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-2-600x371.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-2.png 731w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-5{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-5 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-5{width:100% !important;order : 0;}.fusion-builder-column-5 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-5{width:100% !important;order : 0;}.fusion-builder-column-5 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-6{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-7 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-6 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-8\"><p><strong>5. In the barcode column, add in the formula =\u201d*\u201d&amp;B2&amp;\u201d*\u201d (the letter B corresponds with the column letter and the number 2 corresponds with the row)<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-4 hover-type-none\"><img width=\"549\" height=\"292\" title=\"How to create a barcode\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/Capture.png\" alt class=\"img-responsive wp-image-8304\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/Capture-200x106.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/Capture-400x213.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/Capture.png 549w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 549px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-6{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-6 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-6{width:100% !important;order : 0;}.fusion-builder-column-6 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-6{width:100% !important;order : 0;}.fusion-builder-column-6 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-7{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-8 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-7 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-9\"><p><strong>6. Change your font to Libre Barcode &#8211; either Code 39 or Code 128 (For this article, we chose Libre Code 39)<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-5 hover-type-none\"><img width=\"600\" height=\"411\" title=\"how to create barcode 6\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6-600x411.png\" alt class=\"img-responsive wp-image-7264\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6-200x137.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6-400x274.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6-600x411.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6-800x548.png 800w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-6.png 845w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-7{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-7 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-7{width:100% !important;order : 0;}.fusion-builder-column-7 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-7{width:100% !important;order : 0;}.fusion-builder-column-7 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-8{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-9 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-8 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-10\"><p><span style=\"font-weight: 400;\">At this point you can click and drag the formula down as many columns as you need to create multiple, unique barcodes. <\/span><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-6 hover-type-none\"><img width=\"600\" height=\"277\" title=\"how to create barcode 8\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-8-600x277.png\" alt class=\"img-responsive wp-image-7265\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-8-200x92.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-8-400x185.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-8-600x277.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-barcode-8.png 621w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-8{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-8 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-8{width:100% !important;order : 0;}.fusion-builder-column-8 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-8{width:100% !important;order : 0;}.fusion-builder-column-8 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-9{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-10 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-9 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\">@media only screen and (max-width:1064px) {.fusion-title.fusion-title-2{margin-top:5px!important; margin-right:0px!important;margin-bottom:10px!important;margin-left:0px!important;}}@media only screen and (max-width:640px) {.fusion-title.fusion-title-2{margin-top:0px!important; margin-right:0px!important;margin-bottom:20px!important; margin-left:0px!important;}}<\/style><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-two\" style=\"margin-top:5px;margin-right:0px;margin-bottom:10px;margin-left:0px;\"><h2 class=\"title-heading-left\" style=\"margin:0;\"><strong>Microsoft Excel\u00a0<\/strong><\/h2><\/div><div class=\"fusion-text fusion-text-11\"><p><span style=\"font-weight: 400;\">Below is a step by step look at how to create a barcode in Microsoft Excel for your online business. You will want to make sure you have a barcode font downloaded for this to work properly.<\/span><\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-9{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-9 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-9{width:100% !important;order : 0;}.fusion-builder-column-9 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-9{width:100% !important;order : 0;}.fusion-builder-column-9 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-10{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-11 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-10 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-12\"><p><strong>1. Open Microsoft Excel and start a new spreadsheet<\/strong><\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-10{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-10 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-10{width:100% !important;order : 0;}.fusion-builder-column-10 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-10{width:100% !important;order : 0;}.fusion-builder-column-10 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-11{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-12 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-11 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-13\"><p><strong>2. Organize your business information into columns (i.e. product name\/number, code numbers, customer names, barcodes, etc.)<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-7 hover-type-none\"><img width=\"600\" height=\"378\" title=\"how to create excel 1\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-1-600x378.png\" alt class=\"img-responsive wp-image-7272\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-1-200x126.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-1-400x252.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-1-600x378.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-1.png 627w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-11{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-11 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-11{width:100% !important;order : 0;}.fusion-builder-column-11 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-11{width:100% !important;order : 0;}.fusion-builder-column-11 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-12{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-13 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-12 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-14\"><p><strong>3. Add your products into the spreadsheet<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-8 hover-type-none\"><img width=\"600\" height=\"324\" title=\"how to create excel 6\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-6-600x324.png\" alt class=\"img-responsive wp-image-7282\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-6-200x108.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-6-400x216.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-6-600x324.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-6.png 618w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-12{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-12 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-12{width:100% !important;order : 0;}.fusion-builder-column-12 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-12{width:100% !important;order : 0;}.fusion-builder-column-12 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-13{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-14 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-13 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-15\"><p><strong>4. Give each product its own unique identification number<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-9 hover-type-none\"><img width=\"600\" height=\"325\" title=\"how to create excel 2\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-2-600x325.png\" alt class=\"img-responsive wp-image-7273\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-2-200x108.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-2-400x216.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-2-600x325.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-2.png 623w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-13{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-13 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-13{width:100% !important;order : 0;}.fusion-builder-column-13 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-13{width:100% !important;order : 0;}.fusion-builder-column-13 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-14{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-15 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-14 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-16\"><p><strong>5. In your barcode column, add in the formula =\u201d*\u201d&amp;B2&amp;\u201d*\u201d<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-10 hover-type-none\"><img width=\"600\" height=\"360\" title=\"how to create excel 3\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-3-600x360.png\" alt class=\"img-responsive wp-image-7274\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-3-200x120.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-3-400x240.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-3-600x360.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-3.png 627w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-14{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-14 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-14{width:100% !important;order : 0;}.fusion-builder-column-14 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-14{width:100% !important;order : 0;}.fusion-builder-column-14 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-15{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-16 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-15 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-17\"><p><strong>6. Change your font to Libre Barcode &#8211; either Code 39 or Code 128 (For this article, we chose Libre Code 39)<\/strong><\/p>\n<\/div><div style=\"text-align:center;\"><span class=\" fusion-imageframe imageframe-none imageframe-11 hover-type-none\"><img width=\"600\" height=\"328\" title=\"how to create excel 5\" src=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-5-600x328.png\" alt class=\"img-responsive wp-image-7275\" srcset=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-5-200x109.png 200w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-5-400x219.png 400w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-5-600x328.png 600w, https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2020\/10\/how-to-create-excel-5.png 686w\" sizes=\"(max-width: 1064px) 100vw, (max-width: 640px) 100vw, 600px\" \/><\/span><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-15{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-15 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-15{width:100% !important;order : 0;}.fusion-builder-column-15 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-15{width:100% !important;order : 0;}.fusion-builder-column-15 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-16{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-17 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start\" style=\"max-width:1144px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-16 fusion_builder_column_1_1 1_1 fusion-flex-column\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-18\"><p>Hopefully these quick and easy steps can help you organize and print your barcode labels in an efficient manner.<\/p>\n<\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-builder-column-16{width:100% !important;margin-top : 0px;margin-bottom : 20px;}.fusion-builder-column-16 > .fusion-column-wrapper {padding-top : 0px !important;padding-right : 0px !important;margin-right : 1.92%;padding-bottom : 0px !important;padding-left : 0px !important;margin-left : 1.92%;}@media only screen and (max-width:1064px) {.fusion-body .fusion-builder-column-16{width:100% !important;order : 0;}.fusion-builder-column-16 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}@media only screen and (max-width:640px) {.fusion-body .fusion-builder-column-16{width:100% !important;order : 0;}.fusion-builder-column-16 > .fusion-column-wrapper {margin-right : 1.92%;margin-left : 1.92%;}}<\/style><\/div><\/div><style type=\"text\/css\">.fusion-body .fusion-flex-container.fusion-builder-row-17{ padding-top : 0px;margin-top : 0px;padding-right : 0px;padding-bottom : 0px;margin-bottom : 0px;padding-left : 0px;}<\/style><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You want to utilize barcodes for your business but the software is too expensive. A quick, easy way to aid your inventory and management process is to create a barcode in Excel or Google Sheets. But if you&#8217;ve never utilized these programs before, the process can seem overwhelming. We&#8217;re here to help.<\/p>\n","protected":false},"author":13,"featured_media":12587,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[78],"tags":[],"acf":{"theme_color":"","estimated_reading_time":6,"include_in_most_popular_sidebar":true,"hero_splash_image":12585,"grid_listing_thumbnail":12586,"sidebar_most_popular_thumbnail":12588},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.7.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog<\/title>\n<meta name=\"description\" content=\"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog\" \/>\n<meta property=\"og:description\" content=\"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Barcode Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/smithcoronalabels\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-30T15:40:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-28T16:09:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-create-barcodes-hero-splash.png\" \/>\n\t<meta property=\"og:image:width\" content=\"760\" \/>\n\t<meta property=\"og:image:height\" content=\"460\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alaina D&#039;Altorio\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sclabels\" \/>\n<meta name=\"twitter:site\" content=\"@sclabels\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alaina D'Altorio\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"22 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\"},\"author\":{\"name\":\"Alaina D'Altorio\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/1b9fc3da02d7f7eb09679c7abc90ba43\"},\"headline\":\"How to Create a Barcode In Google Sheets &amp; Microsoft Excel\",\"datePublished\":\"2020-10-30T15:40:27+00:00\",\"dateModified\":\"2023-12-28T16:09:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\"},\"wordCount\":12380,\"publisher\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#organization\"},\"articleSection\":[\"Business Resources\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\",\"url\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\",\"name\":\"How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#website\"},\"datePublished\":\"2020-10-30T15:40:27+00:00\",\"dateModified\":\"2023-12-28T16:09:06+00:00\",\"description\":\"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Home\",\"item\":\"https:\/\/www.smithcorona.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Business Resources\",\"item\":\"https:\/\/www.smithcorona.com\/blog\/category\/business-resources\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Create a Barcode In Google Sheets &amp; Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#website\",\"url\":\"https:\/\/www.smithcorona.com\/blog\/\",\"name\":\"Barcode Blog\",\"description\":\"Lowest Prices On The Planet\",\"publisher\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.smithcorona.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#organization\",\"name\":\"Smith Corona\",\"url\":\"https:\/\/www.smithcorona.com\/blog\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/smith-corona\",\"https:\/\/www.youtube.com\/channel\/UCOspiCuJCRaUToTdCZ-z2Mw\",\"https:\/\/www.facebook.com\/smithcoronalabels\",\"https:\/\/twitter.com\/sclabels\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/logo-22.png\",\"contentUrl\":\"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/logo-22.png\",\"width\":300,\"height\":76,\"caption\":\"Smith Corona\"},\"image\":{\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/1b9fc3da02d7f7eb09679c7abc90ba43\",\"name\":\"Alaina D'Altorio\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1d945e049962652c15b2b946d27887d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1d945e049962652c15b2b946d27887d6?s=96&d=mm&r=g\",\"caption\":\"Alaina D'Altorio\"},\"url\":\"https:\/\/www.smithcorona.com\/blog\/author\/alaina\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog","description":"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog","og_description":"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.","og_url":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/","og_site_name":"Barcode Blog","article_publisher":"https:\/\/www.facebook.com\/smithcoronalabels","article_published_time":"2020-10-30T15:40:27+00:00","article_modified_time":"2023-12-28T16:09:06+00:00","og_image":[{"width":760,"height":460,"url":"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/how-to-create-barcodes-hero-splash.png","type":"image\/png"}],"author":"Alaina D'Altorio","twitter_card":"summary_large_image","twitter_creator":"@sclabels","twitter_site":"@sclabels","twitter_misc":{"Written by":"Alaina D'Altorio","Est. reading time":"22 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/"},"author":{"name":"Alaina D'Altorio","@id":"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/1b9fc3da02d7f7eb09679c7abc90ba43"},"headline":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel","datePublished":"2020-10-30T15:40:27+00:00","dateModified":"2023-12-28T16:09:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/"},"wordCount":12380,"publisher":{"@id":"https:\/\/www.smithcorona.com\/blog\/#organization"},"articleSection":["Business Resources"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/","url":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/","name":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel - Barcode Blog","isPartOf":{"@id":"https:\/\/www.smithcorona.com\/blog\/#website"},"datePublished":"2020-10-30T15:40:27+00:00","dateModified":"2023-12-28T16:09:06+00:00","description":"A quick and easy way to aid your inventory and barcode management process is to create a barcode in Excel or Google Sheets.","breadcrumb":{"@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.smithcorona.com\/blog\/create-a-barcode-in-google-sheets-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/www.smithcorona.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Business Resources","item":"https:\/\/www.smithcorona.com\/blog\/category\/business-resources\/"},{"@type":"ListItem","position":3,"name":"How to Create a Barcode In Google Sheets &amp; Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.smithcorona.com\/blog\/#website","url":"https:\/\/www.smithcorona.com\/blog\/","name":"Barcode Blog","description":"Lowest Prices On The Planet","publisher":{"@id":"https:\/\/www.smithcorona.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.smithcorona.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.smithcorona.com\/blog\/#organization","name":"Smith Corona","url":"https:\/\/www.smithcorona.com\/blog\/","sameAs":["https:\/\/www.linkedin.com\/company\/smith-corona","https:\/\/www.youtube.com\/channel\/UCOspiCuJCRaUToTdCZ-z2Mw","https:\/\/www.facebook.com\/smithcoronalabels","https:\/\/twitter.com\/sclabels"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smithcorona.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/logo-22.png","contentUrl":"https:\/\/www.smithcorona.com\/blog\/wp-content\/uploads\/2022\/09\/logo-22.png","width":300,"height":76,"caption":"Smith Corona"},"image":{"@id":"https:\/\/www.smithcorona.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/1b9fc3da02d7f7eb09679c7abc90ba43","name":"Alaina D'Altorio","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.smithcorona.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1d945e049962652c15b2b946d27887d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d945e049962652c15b2b946d27887d6?s=96&d=mm&r=g","caption":"Alaina D'Altorio"},"url":"https:\/\/www.smithcorona.com\/blog\/author\/alaina\/"}]}},"_links":{"self":[{"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/posts\/7249"}],"collection":[{"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/comments?post=7249"}],"version-history":[{"count":6,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/posts\/7249\/revisions"}],"predecessor-version":[{"id":15224,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/posts\/7249\/revisions\/15224"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/media\/12587"}],"wp:attachment":[{"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/media?parent=7249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/categories?post=7249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.smithcorona.com\/blog\/wp-json\/wp\/v2\/tags?post=7249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}