{"id":8416,"date":"2022-11-18T18:28:21","date_gmt":"2022-11-18T18:28:21","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8416"},"modified":"2023-11-29T18:00:50","modified_gmt":"2023-11-29T18:00:50","slug":"excel-autofit-column-shortcut","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/","title":{"rendered":"How to AutoFit Column Width in Excel? [Shortcut]"},"content":{"rendered":"<h3><strong>AutoFit columns width in Excel<\/strong><\/h3>\n<div class=\"top-style-2\">\n<p>While going through reports or data in Excel, you might come across columns with content filled with the <strong>hash (#)<\/strong> signs or contents going across the other columns or hidden due to less width.<\/p>\n<p>That means, the width of the column is less than the content it contains and you may need to pull the header of each column to expand it.<\/p>\n<p>So how to expand the width of the column so that it shows the whole content it contains?<\/p>\n<p>Use the shortcut below:<\/p>\n<\/div>\n<div class=\"keys\">\n<div class=\"key__button\" data-key=\"65\">Alt<\/div>\n<div class=\"key__button\" data-key=\"65\">H<\/div>\n<div class=\"key__button\" data-key=\"65\">O<\/div>\n<div class=\"key__button\" data-key=\"65\">I<\/div>\n<\/div>\n<h3><strong>Video demonstration of AutoFit column width by <\/strong>Alt + H + O + I<\/h3>\n<p>See the video below to watch how the width of the column is adjusted by using:<\/p>\n<div class=\"keys\">\n<div class=\"key__button\" data-key=\"65\">Alt<\/div>\n<div class=\"key__button\" data-key=\"65\">H<\/div>\n<div class=\"key__button\" data-key=\"65\">O<\/div>\n<div class=\"key__button\" data-key=\"65\">I<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" title=\"Excel AutoFit Columns To View Full Data - Shortcut  Alt H O I\" width=\"640\" height=\"480\" src=\"https:\/\/www.youtube.com\/embed\/kChFgsvzbdI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3><strong>Steps to follow to expand all columns by using the shortcut<\/strong><\/h3>\n<p>Follow these steps to AutoFit all required columns to their contents.<\/p>\n<div class=\"stepsstyle\"><strong>Step 1:<\/strong><\/div>\n<p>Select the columns that you wish to AutoFit as per their contents.<\/p>\n<div class=\"stepsstyle\"><strong>Step2<\/strong><\/div>\n<p>Press the following keys:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8417\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\" alt=\"\" width=\"214\" height=\"52\" \/><\/p>\n<div class=\"note-div\"><strong>Note:<\/strong> (You may press keys one by one \u2013 do not need to hold all keys)<\/div>\n<p>In our video, we selected columns A to D and the shortcut expanded all columns.<\/p>\n<p>You can also see menus open as you keep pressing the keys.<\/p>\n<h3><strong>Expand only specific columns?<\/strong><\/h3>\n<p>As you can see in the video, column B is already showing full content and it does not need to expand. In other words, you only want to expand fewer columns per their contents. This is how you may do it:<\/p>\n<p>Suppose we want to AutoFit only columns A and C.<\/p>\n<div class=\"stepsstyle\"><strong>Step 1:<\/strong><\/div>\n<p>Press <strong>ctrl<\/strong> key<\/p>\n<div class=\"stepsstyle\"><strong>Step 2:<\/strong><\/div>\n<p>Select <strong>column A<\/strong> from its header (while keep pressing the ctrl key)<\/p>\n<div class=\"stepsstyle\"><strong>Step 3<\/strong><\/div>\n<p>Select <strong>column C<\/strong> from its header and <strong>release<\/strong> the <strong>ctrl<\/strong> key<\/p>\n<div class=\"stepsstyle\"><strong>Step 4<\/strong><\/div>\n<p>Press the following keys<\/p>\n<div class=\"keys\">\n<div class=\"key__button\" data-key=\"65\">Alt<\/div>\n<div class=\"key__button\" data-key=\"65\">H<\/div>\n<div class=\"key__button\" data-key=\"65\">O<\/div>\n<div class=\"key__button\" data-key=\"65\">I<\/div>\n<\/div>\n<p>&nbsp;&nbsp;<\/p>\n<p>This should expand only columns A and C.<\/p>\n<p><strong>Still confused? See the video demonstration below:<\/strong><\/p>\n<p><iframe loading=\"lazy\" title=\"Excel AutoFit Specific Columns - Alt H O I\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/wP2D5G9th-c?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8417,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[143],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to AutoFit Column Width in Excel? [Shortcut]<\/title>\n<meta name=\"description\" content=\"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...\" \/>\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.excel-learn.com\/excel-autofit-column-shortcut\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to AutoFit Column Width in Excel? [Shortcut]\" \/>\n<meta property=\"og:description\" content=\"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-18T18:28:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-29T18:00:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"214\" \/>\n\t<meta property=\"og:image:height\" content=\"52\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"excelmaster\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"excelmaster\" \/>\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:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\"},\"author\":{\"name\":\"excelmaster\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"headline\":\"How to AutoFit Column Width in Excel? [Shortcut]\",\"datePublished\":\"2022-11-18T18:28:21+00:00\",\"dateModified\":\"2023-11-29T18:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\"},\"wordCount\":345,\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\",\"articleSection\":[\"Excel Tricks\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\",\"url\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\",\"name\":\"How to AutoFit Column Width in Excel? [Shortcut]\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\",\"datePublished\":\"2022-11-18T18:28:21+00:00\",\"dateModified\":\"2023-11-29T18:00:50+00:00\",\"description\":\"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg\",\"width\":214,\"height\":52},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excel-learn.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to AutoFit Column Width in Excel? [Shortcut]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.excel-learn.com\/#organization\",\"name\":\"Excel Tutorials\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"width\":227,\"height\":48,\"caption\":\"Excel Tutorials\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"},\"url\":\"https:\/\/www.excel-learn.com\/author\/jqueryaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to AutoFit Column Width in Excel? [Shortcut]","description":"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...","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.excel-learn.com\/excel-autofit-column-shortcut\/","og_locale":"en_US","og_type":"article","og_title":"How to AutoFit Column Width in Excel? [Shortcut]","og_description":"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...","og_url":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/","og_site_name":"Excel Tutorials","article_published_time":"2022-11-18T18:28:21+00:00","article_modified_time":"2023-11-29T18:00:50+00:00","og_image":[{"width":214,"height":52,"url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg","type":"image\/jpeg"}],"author":"excelmaster","twitter_misc":{"Written by":"excelmaster","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#article","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/"},"author":{"name":"excelmaster","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3"},"headline":"How to AutoFit Column Width in Excel? [Shortcut]","datePublished":"2022-11-18T18:28:21+00:00","dateModified":"2023-11-29T18:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/"},"wordCount":345,"publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"image":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg","articleSection":["Excel Tricks"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/","url":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/","name":"How to AutoFit Column Width in Excel? [Shortcut]","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage"},"image":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg","datePublished":"2022-11-18T18:28:21+00:00","dateModified":"2023-11-29T18:00:50+00:00","description":"So how to expand the width of the column so that it shows the whole content it contains? Use the shortcut...","breadcrumb":{"@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#primaryimage","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/11\/Excel-alt_H_O_I.jpg","width":214,"height":52},{"@type":"BreadcrumbList","@id":"https:\/\/www.excel-learn.com\/excel-autofit-column-shortcut\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excel-learn.com\/"},{"@type":"ListItem","position":2,"name":"How to AutoFit Column Width in Excel? [Shortcut]"}]},{"@type":"WebSite","@id":"https:\/\/www.excel-learn.com\/#website","url":"https:\/\/www.excel-learn.com\/","name":"Excel Tutorials","description":"Tips, Solutions, Tricks","publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excel-learn.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.excel-learn.com\/#organization","name":"Excel Tutorials","url":"https:\/\/www.excel-learn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","width":227,"height":48,"caption":"Excel Tutorials"},"image":{"@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3","name":"excelmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","caption":"excelmaster"},"url":"https:\/\/www.excel-learn.com\/author\/jqueryaz\/"}]}},"_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8416"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8416"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8416\/revisions"}],"predecessor-version":[{"id":9960,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8416\/revisions\/9960"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/8417"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}