{"id":4248,"date":"2023-12-27T20:36:07","date_gmt":"2023-12-27T20:36:07","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4248"},"modified":"2026-01-20T15:53:23","modified_gmt":"2026-01-20T15:53:23","slug":"inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/","title":{"rendered":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW?"},"content":{"rendered":"

Inserting Spacer Rows and Columns in an Exploration View<\/strong><\/p>\n

With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns currently cannot be formatted just as the other rows, columns, and cells in the exploration view.<\/p>\n

Adding Spacers<\/strong><\/p>\n

To insert a spacer, select a row or column within the exploration view and then right click on the header to open a menu. Select the \u201cAdd Spacers\u201d option, then select the \u201cBefore Selection\u201d or \u201cAfter Selection\u201d option based on where the spacer should be created. Multiple rows or columns can be selected to add multiple spacers simultaneously.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Note that spacer rows and columns can cause spreading options that would include spacer cells to not function as intended. In the example below, the spread functions correctly in the first set of images, but stops before the added spacer column instead in the second example.<\/p>\n

Without Spacer:<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

With Spacer:<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Removing Spacers<\/strong><\/p>\n

To remove a spacer row or column right click on the header cell of the spacer and then select the \u201cRemove\u201d option. Multiple spacers can be selected to remove them simultaneously.<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Inserting Spacer Rows and Columns in an Exploration View With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[51,95],"class_list":["post-4248","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-planning-analytics-how-tos","tag-planning-analytics-workspace"],"acf":[],"yoast_head":"\nHow Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Inserting Spacer Rows and Columns in an Exploration View With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-27T20:36:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:53:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"584\" \/>\n\t<meta property=\"og:image:height\" content=\"449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW?\",\"datePublished\":\"2023-12-27T20:36:07+00:00\",\"dateModified\":\"2026-01-20T15:53:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/\"},\"wordCount\":227,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Picture1-2.png\",\"keywords\":[\"Planning Analytics How To's\",\"Planning Analytics Workspace\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/\",\"name\":\"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Picture1-2.png\",\"datePublished\":\"2023-12-27T20:36:07+00:00\",\"dateModified\":\"2026-01-20T15:53:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Picture1-2.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Picture1-2.png\",\"width\":584,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT","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:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT","og_description":"Inserting Spacer Rows and Columns in an Exploration View With the release of Planning Analytics Workspace version 2.0.90 the ability to add spacer rows and columns has been added. This feature is useful for customizing the presentation of views within books by separating data presentation and improving readability. As of writing, spacer rows and columns…","og_url":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/","og_site_name":"QueBIT","article_published_time":"2023-12-27T20:36:07+00:00","article_modified_time":"2026-01-20T15:53:23+00:00","og_image":[{"width":584,"height":449,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png","type":"image\/png"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW?","datePublished":"2023-12-27T20:36:07+00:00","dateModified":"2026-01-20T15:53:23+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/"},"wordCount":227,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png","keywords":["Planning Analytics How To's","Planning Analytics Workspace"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/","url":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/","name":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png","datePublished":"2023-12-27T20:36:07+00:00","dateModified":"2026-01-20T15:53:23+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2023\/12\/Picture1-2.png","width":584,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/inserting-spacer-rows-and-columns-in-an-exploration-view-in-paw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Insert Spacer Rows and Columns in an Exploration View in PAW?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4248"}],"version-history":[{"count":4,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4248\/revisions"}],"predecessor-version":[{"id":5067,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4248\/revisions\/5067"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}