{"id":3279,"date":"2015-01-27T04:14:59","date_gmt":"2015-01-27T09:44:59","guid":{"rendered":"http:\/\/news.filepuma.com\/?p=3279"},"modified":"2024-07-15T19:04:06","modified_gmt":"2024-07-16T02:04:06","slug":"how-to-lock-pivot-table-size-in-excel","status":"publish","type":"post","link":"https:\/\/www.filepuma.com\/reviews\/how-to-lock-pivot-table-size-in-excel\/","title":{"rendered":"How to Lock Pivot Table Size in Excel"},"content":{"rendered":"<p>Microsoft Excel is a great program, it would need some adjustment to get the data to display or print correctly on a page. However, some little changes in size will break the whole layout if the data is a tight fit. In case the wrong this happened, we need to lock the table. Here is the instruction.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3280\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/01\/Hytbs43754c75a65d5bd0113756303.gif\" alt=\"excel1\" width=\"598\" height=\"472\" \/><\/p>\n<p>1. Run Excel program by double clicking the icon.<\/p>\n<p>2. Right-click any cell in a pivot table and select &#8220;PivotTable Options.&#8221;<\/p>\n<p>3. Select the &#8220;Layout &amp; Format&#8221; tab.<\/p>\n<p>4. Keep &#8220;Autofit Column Widths on Update&#8221; unchecked.<\/p>\n<p>5. Click &#8220;OK&#8221; to save the change.<\/p>\n<p>6. Now Excel will no longer adjust the column width for this pivot table when the data changes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a great program, it would need some adjustment to get the data to display or print correctly on a page. However, some little changes in size will break the whole layout if the data is a tight fit. In case the wrong this happened, we need to lock the table. Here is [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[],"class_list":["post-3279","post","type-post","status-publish","format-standard","hentry","category-business"],"_links":{"self":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/comments?post=3279"}],"version-history":[{"count":1,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3279\/revisions"}],"predecessor-version":[{"id":5217,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3279\/revisions\/5217"}],"wp:attachment":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/media?parent=3279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/categories?post=3279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/tags?post=3279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}