{"id":14462,"date":"2023-05-23T00:48:15","date_gmt":"2023-05-23T04:48:15","guid":{"rendered":"https:\/\/network1consulting.com\/?p=14462"},"modified":"2023-05-17T10:10:22","modified_gmt":"2023-05-17T14:10:22","slug":"tuesday-tip-save-time-in-excel-with-autofit","status":"publish","type":"post","link":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/","title":{"rendered":"Tuesday Tip: Save Time in Excel with Autofit"},"content":{"rendered":"<p style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-14471 size-medium\" src=\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/2-excel-combined-150x300.png\" alt=\"\" width=\"150\" height=\"300\" srcset=\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/2-excel-combined-150x300.png 150w, https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/2-excel-combined-512x1024.png 512w, https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/2-excel-combined.png 625w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>When starting a new excel spreadsheet, columns are set to a standard width of 8.43. Simply put: you\u2019ve only got so many characters you can type into cells before you start seeing something like this:<\/p>\n<p style=\"font-weight: 400;\">It is easy to manually widen those cells so you can see the data, but by using a very basic macro the columns can autofit on the fly as you enter and subtract data.<\/p>\n<p style=\"font-weight: 400;\"><em>FYI: A macro is an embedded command in excel that automates tasks in the spreadsheet. Note \u2013 sometimes your \u2018IT\u2019 department will disable macros in office products as they can be used to distribute malicious code, so check with your IT team if you aren\u2019t able to get this to work.<\/em><\/p>\n<ol>\n<li>Right click on the <strong><em>sheet<\/em><\/strong> tab at the bottom and select <em><strong>View Code<\/strong><\/em><\/li>\n<li>A new window will pop up called <em><strong>Microsoft Visual Basic for Applications<\/strong><\/em>\n<ul>\n<li>Select<em><strong> Worksheet<\/strong><\/em> in the first drop down menu<\/li>\n<li>In the area below that, type: <em><strong>Cells.EntireColumn.AutoFit<\/strong><\/em><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-full wp-image-14465\" src=\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/excel-3.png\" alt=\"\" width=\"624\" height=\"204\" srcset=\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/excel-3.png 624w, https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/excel-3-300x98.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/>Close out of that window once you have entered the code. This command is now embedded in your sheet, so as you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.<\/p>\n<p style=\"font-weight: 400;\">If you are dealing with lots of data, this can be a great time saver.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When starting a new excel spreadsheet, columns are set to a standard width of 8.43. Simply put: you\u2019ve only got so many characters you can type into cells before you start seeing something like this: It is easy to manually widen those cells so you can see the data, but by using a very basic&hellip;<\/p>\n","protected":false},"author":3,"featured_media":14464,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4,28,32,33,34],"tags":[1741,1742,1115],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tuesday Tip: Save Time in Excel with Autofit - network1<\/title>\n<meta name=\"description\" content=\"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tuesday Tip: Save Time in Excel with Autofit - network1\" \/>\n<meta property=\"og:description\" content=\"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\" \/>\n<meta property=\"og:site_name\" content=\"network1\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-23T04:48:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-17T14:10:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"236\" \/>\n\t<meta property=\"og:image:height\" content=\"326\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"bonnieb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Richard Stokes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\"},\"author\":{\"name\":\"bonnieb\",\"@id\":\"https:\/\/network1consulting.com\/#\/schema\/person\/539c73925fea9ede65112a8fe181857b\"},\"headline\":\"Tuesday Tip: Save Time in Excel with Autofit\",\"datePublished\":\"2023-05-23T04:48:15+00:00\",\"dateModified\":\"2023-05-17T14:10:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\"},\"wordCount\":227,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/network1consulting.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png\",\"keywords\":[\"excel column width\",\"excel hacks\",\"Microsoft Excel\"],\"articleSection\":[\"Blog \/ Tuesday Tips\",\"Network 1 Consulting\",\"Technology\",\"Time savers\",\"tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\",\"url\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\",\"name\":\"Tuesday Tip: Save Time in Excel with Autofit - network1\",\"isPartOf\":{\"@id\":\"https:\/\/network1consulting.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png\",\"datePublished\":\"2023-05-23T04:48:15+00:00\",\"dateModified\":\"2023-05-17T14:10:22+00:00\",\"description\":\"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.\",\"breadcrumb\":{\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage\",\"url\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png\",\"contentUrl\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png\",\"width\":236,\"height\":326},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/network1consulting.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tuesday Tip: Save Time in Excel with Autofit\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/network1consulting.com\/#website\",\"url\":\"https:\/\/network1consulting.com\/\",\"name\":\"Network 1 Consulting\",\"description\":\"Worry Free IT\",\"publisher\":{\"@id\":\"https:\/\/network1consulting.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/network1consulting.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/network1consulting.com\/#organization\",\"name\":\"Network 1 Consulting\",\"url\":\"https:\/\/network1consulting.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/network1consulting.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2020\/11\/25th-logo.png\",\"contentUrl\":\"https:\/\/network1consulting.com\/wp-content\/uploads\/2020\/11\/25th-logo.png\",\"width\":3198,\"height\":1561,\"caption\":\"Network 1 Consulting\"},\"image\":{\"@id\":\"https:\/\/network1consulting.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/network1consulting.com\/#\/schema\/person\/539c73925fea9ede65112a8fe181857b\",\"name\":\"bonnieb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/network1consulting.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ebcca890d0436e8ce76205d20def63ac?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ebcca890d0436e8ce76205d20def63ac?s=96&d=mm&r=g\",\"caption\":\"bonnieb\"},\"url\":\"https:\/\/network1consulting.com\/author\/bonnieb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tuesday Tip: Save Time in Excel with Autofit - network1","description":"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.","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:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/","og_locale":"en_US","og_type":"article","og_title":"Tuesday Tip: Save Time in Excel with Autofit - network1","og_description":"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.","og_url":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/","og_site_name":"network1","article_published_time":"2023-05-23T04:48:15+00:00","article_modified_time":"2023-05-17T14:10:22+00:00","og_image":[{"width":236,"height":326,"url":"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png","type":"image\/png"}],"author":"bonnieb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Richard Stokes","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#article","isPartOf":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/"},"author":{"name":"bonnieb","@id":"https:\/\/network1consulting.com\/#\/schema\/person\/539c73925fea9ede65112a8fe181857b"},"headline":"Tuesday Tip: Save Time in Excel with Autofit","datePublished":"2023-05-23T04:48:15+00:00","dateModified":"2023-05-17T14:10:22+00:00","mainEntityOfPage":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/"},"wordCount":227,"commentCount":0,"publisher":{"@id":"https:\/\/network1consulting.com\/#organization"},"image":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage"},"thumbnailUrl":"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png","keywords":["excel column width","excel hacks","Microsoft Excel"],"articleSection":["Blog \/ Tuesday Tips","Network 1 Consulting","Technology","Time savers","tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/","url":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/","name":"Tuesday Tip: Save Time in Excel with Autofit - network1","isPartOf":{"@id":"https:\/\/network1consulting.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage"},"image":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage"},"thumbnailUrl":"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png","datePublished":"2023-05-23T04:48:15+00:00","dateModified":"2023-05-17T14:10:22+00:00","description":"As you populate data into cells, Excel will automatically adjust the width of your columns to fit the data you are entering.","breadcrumb":{"@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#primaryimage","url":"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png","contentUrl":"https:\/\/network1consulting.com\/wp-content\/uploads\/2023\/05\/Excel-2.png","width":236,"height":326},{"@type":"BreadcrumbList","@id":"https:\/\/network1consulting.com\/tuesday-tip-save-time-in-excel-with-autofit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/network1consulting.com\/"},{"@type":"ListItem","position":2,"name":"Tuesday Tip: Save Time in Excel with Autofit"}]},{"@type":"WebSite","@id":"https:\/\/network1consulting.com\/#website","url":"https:\/\/network1consulting.com\/","name":"Network 1 Consulting","description":"Worry Free IT","publisher":{"@id":"https:\/\/network1consulting.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/network1consulting.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/network1consulting.com\/#organization","name":"Network 1 Consulting","url":"https:\/\/network1consulting.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/network1consulting.com\/#\/schema\/logo\/image\/","url":"https:\/\/network1consulting.com\/wp-content\/uploads\/2020\/11\/25th-logo.png","contentUrl":"https:\/\/network1consulting.com\/wp-content\/uploads\/2020\/11\/25th-logo.png","width":3198,"height":1561,"caption":"Network 1 Consulting"},"image":{"@id":"https:\/\/network1consulting.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/network1consulting.com\/#\/schema\/person\/539c73925fea9ede65112a8fe181857b","name":"bonnieb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/network1consulting.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ebcca890d0436e8ce76205d20def63ac?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ebcca890d0436e8ce76205d20def63ac?s=96&d=mm&r=g","caption":"bonnieb"},"url":"https:\/\/network1consulting.com\/author\/bonnieb\/"}]}},"_links":{"self":[{"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/posts\/14462"}],"collection":[{"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/comments?post=14462"}],"version-history":[{"count":5,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/posts\/14462\/revisions"}],"predecessor-version":[{"id":14473,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/posts\/14462\/revisions\/14473"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/media\/14464"}],"wp:attachment":[{"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/media?parent=14462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/categories?post=14462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/network1consulting.com\/wp-json\/wp\/v2\/tags?post=14462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}