{"id":23045,"date":"2019-03-30T22:17:00","date_gmt":"2019-03-30T16:47:00","guid":{"rendered":"https:\/\/mywindowshub.com\/?p=23045"},"modified":"2019-03-31T03:15:42","modified_gmt":"2019-03-30T21:45:42","slug":"how-to-resize-a-table-column-or-a-row-in-ms-excel","status":"publish","type":"post","link":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/","title":{"rendered":"How To Resize A Table, Column, Or A Row In MS Excel?"},"content":{"rendered":"\n<p>Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table. You can create graphs, pie charts, trends of a particular business or scientific model and so on. The number of features are almost endless.<\/p>\n\n\n\n<p>Microsoft Office Excel is humongously used in research and study purposes. It has an amazing set of features that help users to perform complex mathematical formulae and functions. However, Excel also covers deveral formatting options which might be necessary for creating a complete Excel sheet.&nbsp; Sometimes, you might feel the need to increase of decrease the width of a column, row or a table. You can manually adjust the column width or row height or automatically resize columns and rows to fit the data but that may not be the same in every case. So, you can set the width of the row, column or table or choose an option to make the column or row content automatically fit into the tabs.<\/p>\n\n\n\n<p>In this article, we shall show you how to adjust the width of the row, column and table in MS Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps To Resize A Table, Column, Or A Row In MS Excel<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\">Steps To Resize Rows in MS Excel<\/h4>\n\n\n\n<p>First of all, select a row or a range of\nrows.<\/p>\n\n\n\n<p>Select Format option from the panel above. Next, choose Row Width.&nbsp;&nbsp; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/rowht-1.jpg\" alt=\"row height\"\/><\/figure>\n\n\n\n<p>Now type a value for the Row Width and click OK.&nbsp; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/rowht-2.jpg\" alt=\"row ht set\"\/><\/figure>\n\n\n\n<p>If you want to autofit the content, then follow step 1 and then choose Auto Fit Row Height.&nbsp; <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/rowht-3.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Steps To Resize Columns in MS Excel<\/h4>\n\n\n\n<p>First of all, select a column or range of\ncolumns.<\/p>\n\n\n\n<p>Next, go to Format Menu and click on Column Width.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img.mywindowshub.com\/images9\/rowht-4.jpg\" alt=\"column width\"\/><\/figure>\n\n\n\n<p>Type the Column width you want. Hit OK to\nsave. <\/p>\n\n\n\n<p>If you want to autofit the column height, then follow step 1 and then choose Auto Fit Column Height.<\/p>\n\n\n\n<p>That&#8217;s all!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table. You can create graphs, pie charts, trends of a particular business or scientific model and so on. The number of features are almost endless. Microsoft Office Excel is humongously used in research [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":23052,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[253],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Resize A Table, Column, Or A Row In MS Excel?<\/title>\n<meta name=\"description\" content=\"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Resize A Table, Column, Or A Row In MS Excel?\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"My Windows Hub\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-30T16:47:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-30T21:45:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2019\/03\/rowht-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"695\" \/>\n\t<meta property=\"og:image:height\" content=\"405\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Debaleena\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Debaleena\" \/>\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:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\"},\"author\":{\"name\":\"Debaleena\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\"},\"headline\":\"How To Resize A Table, Column, Or A Row In MS Excel?\",\"datePublished\":\"2019-03-30T16:47:00+00:00\",\"dateModified\":\"2019-03-30T21:45:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\"},\"wordCount\":335,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"articleSection\":[\"MS Office Guide\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\",\"url\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\",\"name\":\"How To Resize A Table, Column, Or A Row In MS Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/mywindowshub.com\/#website\"},\"datePublished\":\"2019-03-30T16:47:00+00:00\",\"dateModified\":\"2019-03-30T21:45:42+00:00\",\"description\":\"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.\",\"breadcrumb\":{\"@id\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mywindowshub.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Resize A Table, Column, Or A Row In MS Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mywindowshub.com\/#website\",\"url\":\"https:\/\/mywindowshub.com\/\",\"name\":\"My Windows Hub\",\"description\":\"Windows tutorials, themes, news and updates\",\"publisher\":{\"@id\":\"https:\/\/mywindowshub.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mywindowshub.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/mywindowshub.com\/#organization\",\"name\":\"mywindowshub.com\",\"url\":\"https:\/\/mywindowshub.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"contentUrl\":\"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png\",\"width\":494,\"height\":149,\"caption\":\"mywindowshub.com\"},\"image\":{\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44\",\"name\":\"Debaleena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g\",\"caption\":\"Debaleena\"},\"description\":\"Happiness is that best therapy. Use it to heal yourself and then others!\",\"sameAs\":[\"http:\/\/warbleoflife.blogspot.in\/\"],\"url\":\"https:\/\/mywindowshub.com\/author\/debaleena\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Resize A Table, Column, Or A Row In MS Excel?","description":"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.","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:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"How To Resize A Table, Column, Or A Row In MS Excel?","og_description":"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.","og_url":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/","og_site_name":"My Windows Hub","article_published_time":"2019-03-30T16:47:00+00:00","article_modified_time":"2019-03-30T21:45:42+00:00","og_image":[{"width":695,"height":405,"url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2019\/03\/rowht-2.png","type":"image\/png"}],"author":"Debaleena","twitter_misc":{"Written by":"Debaleena","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#article","isPartOf":{"@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/"},"author":{"name":"Debaleena","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44"},"headline":"How To Resize A Table, Column, Or A Row In MS Excel?","datePublished":"2019-03-30T16:47:00+00:00","dateModified":"2019-03-30T21:45:42+00:00","mainEntityOfPage":{"@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/"},"wordCount":335,"commentCount":0,"publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"articleSection":["MS Office Guide"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/","url":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/","name":"How To Resize A Table, Column, Or A Row In MS Excel?","isPartOf":{"@id":"https:\/\/mywindowshub.com\/#website"},"datePublished":"2019-03-30T16:47:00+00:00","dateModified":"2019-03-30T21:45:42+00:00","description":"Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table.","breadcrumb":{"@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mywindowshub.com\/how-to-resize-a-table-column-or-a-row-in-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mywindowshub.com\/"},{"@type":"ListItem","position":2,"name":"How To Resize A Table, Column, Or A Row In MS Excel?"}]},{"@type":"WebSite","@id":"https:\/\/mywindowshub.com\/#website","url":"https:\/\/mywindowshub.com\/","name":"My Windows Hub","description":"Windows tutorials, themes, news and updates","publisher":{"@id":"https:\/\/mywindowshub.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mywindowshub.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/mywindowshub.com\/#organization","name":"mywindowshub.com","url":"https:\/\/mywindowshub.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/","url":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","contentUrl":"https:\/\/mywindowshub.com\/wp-content\/uploads\/2018\/07\/mywindows.png","width":494,"height":149,"caption":"mywindowshub.com"},"image":{"@id":"https:\/\/mywindowshub.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/76bca69fe3d6504d9b8d96948af6cd44","name":"Debaleena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mywindowshub.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14adf9a60a4ffb992db2776601951629?s=96&d=wavatar&r=g","caption":"Debaleena"},"description":"Happiness is that best therapy. Use it to heal yourself and then others!","sameAs":["http:\/\/warbleoflife.blogspot.in\/"],"url":"https:\/\/mywindowshub.com\/author\/debaleena\/"}]}},"_links":{"self":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/23045"}],"collection":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/comments?post=23045"}],"version-history":[{"count":5,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/23045\/revisions"}],"predecessor-version":[{"id":23206,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/posts\/23045\/revisions\/23206"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media\/23052"}],"wp:attachment":[{"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/media?parent=23045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/categories?post=23045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mywindowshub.com\/wp-json\/wp\/v2\/tags?post=23045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}