{"id":454262,"date":"2021-09-07T13:11:44","date_gmt":"2021-09-07T20:11:44","guid":{"rendered":"https:\/\/www.esri.com\/about\/newsroom\/?post_type=arcuser&p=454262"},"modified":"2021-09-07T13:11:44","modified_gmt":"2021-09-07T20:11:44","slug":"ten-tips-for-tables-in-layouts","status":"publish","type":"arcuser","link":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts","title":{"rendered":"Ten Tips for Tables in Layouts"},"author":1031,"featured_media":0,"menu_order":0,"template":"","format":"standard","meta":{"_acf_changed":false,"sync_status":"","episode_type":"","audio_file":"","castos_file_data":"","podmotor_file_id":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","filesize_raw":"","date_recorded":"","explicit":"","block":"","itunes_episode_number":"","itunes_title":"","itunes_season_number":"","itunes_episode_type":"","_links_to":"","_links_to_target":""},"categories":[10412,25022],"tags":[475682,475592,178472,419072],"arcuser_issues":[475582],"class_list":["post-454262","arcuser","type-arcuser","status-publish","format-standard","hentry","category-arcgis-pro","category-hands-on","tag-arcgis-pro-tables","tag-arcuser-summer-2021","tag-best-practices","tag-productivity","arcuser_issues-au-summer-2021"],"acf":{"short_description":"GIS software tips for mastering ArcGIS Pro tables to communicate information more effectively. ","pdf":{"host_remotely":false,"file":454462,"file_url":""},"flexible_content":[{"acf_fc_layout":"blockquote","content":"Tables are a powerful way to share information in an ArcGIS Pro layout. Table frames in a layout support a lot of formatting options\u2014so many that it can be hard to remember them all. Here are my 10 tricks for tables in layouts. (Just try saying that fast 10 times.)"},{"acf_fc_layout":"image","image":454492,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":454502,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":454512,"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":454522,"image_position":"left","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"image","image":454552,"image_position":"left","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

1. Frames versus Fields<\/h2>\r\nFirst, it is important to understand the difference between a table frame and table frame fields. The table frame is the layout container for the table data, just as the map frame is the layout container for a map. Table frame fields are individual fields in the table that are displayed as columns.\r\n\r\nSome properties belong to the table. For example, controlling whether all the data is displayed or just data visible in the map frame is a property of the table frame. To access the properties for the table frame, select it in the Contents pane, right-click, and choose Properties.\r\n\r\nOther properties, such as using word wrapping to determine field width, are set at the field level. By default, all fields in the table frame have the same properties, but you can edit properties for individual fields. For example, you can make the background of the first field blue and make the background for other fields gray. To access the properties for table frame fields, select one or more in the Contents pane, right-click, and choose Properties.\r\n

2. Add, Remove, and Reorder Fields<\/h2>\r\nYou can add, remove, and reorder fields in the table frame directly from the Contents pane. By default, only the first 10 fields are added to a table frame, so knowing how to add and remove fields is incredibly helpful. Simply right-click the table frame in the Contents pane and choose Add field. To remove a field, expand the table, right-click on the desired field, and choose Remove.\r\n

3. Table Striping<\/h2>\r\nChanging the background for alternating rows can help your table data pop. In the table properties, you can set one or two different row backgrounds and choose how many consecutive rows that background appears on. There are a lot of possible combinations.\r\n

4. Number Formatting<\/h2>\r\nThe appearance of numbers in your table reflects the number formatting settings in the table fields view. You can adjust these settings to show numbers as currency, percentages, and other formats. You can also control the number of decimal places displayed and whether a thousands separator is shown.\r\n

5. Sorting<\/h2>\r\nYou can sort the table based on any field included in the table frame by modifying the table frame formatting. Text fields are sorted alphabetically, and numeric fields are sorted numerically. Date fields are sorted by date. With Custom Sort, multiple fields can be used for sorting.\r\n

6. Alignment<\/h2>\r\nYou can set the alignment for individual table frame fields. Sometimes I like to have my text fields aligned to the left and my numeric fields aligned to the right. That can be done by selecting the field you want to align, changing the drop-down to Data text (so that only the field text is modified, not the heading), and setting the alignment.\r\n

7. Gaps<\/h2>\r\nTables will automatically wrap to new columns if the data is too long. You can use other table frame fitting strategies to modify this behavior. You can change the gap between columns. If you want to make your table more compact, try decreasing the gap sizes of other table elements by adjusting the table frame spacing properties.\r\n

8. Use Definition Queries<\/h2>\r\nDisplaying all the spatial features in a table can take up a lot of space. Consider creating a duplicate invisible layer or a stand-alone table and adding a definition query to display only the most important features in that table.\r\n

9. Quickly Update Fonts<\/h2>\r\nThere are a lot of ways to set text properties for tables. You can have different text properties for each field if you\u2019d like or just set different properties for headings and text. Or set properties just for one field. You decide. I often find that I just need to quickly update the font or text color for all text in my table, so instead of poking through the pane, I just use the Format tab on the ribbon. Font settings that are updated there will be applied to all the text in the table.\r\n

10. Table Frame or Table Dynamic Text<\/h2>\r\nSometimes, you can\u2019t get a table to look the way you want, or you don\u2019t want to display headings. Consider using table dynamic text instead of a table. Table dynamic text reads values from a table in your map and displays them as text. If those values are updated, the text is automatically updated (that\u2019s why it\u2019s called dynamic). Table dynamic text supports custom queries to determine what data is shown, and it uses ArcGIS Arcade expressions to format the displayed text. If a table just isn\u2019t working, dynamic table text might do the trick. Watch this video<\/a>\u00a0to find out more about using table dynamic text.\r\n

That\u2019s It<\/h2>\r\nHere you have it: 10 tricks for tables in layouts. Have fun formatting table frames for your next layout. For detailed information on using tables, read the Tables topic in the ArcGIS Pro help documentation at https:\/\/bit.ly\/3iVlI8F."}],"references":null},"yoast_head":"\nThe best ways to format ArcGIS Pro tables in layouts<\/title>\n<meta name=\"description\" content=\"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.\" \/>\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.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ten Tips for Tables in Layouts\" \/>\n<meta property=\"og:description\" content=\"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts\" \/>\n<meta property=\"og:site_name\" content=\"Esri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2021\/08\/10tips_banner.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@Esri\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\n\t \"@context\": \"https:\/\/schema.org\",\n\t \"@graph\": [\n\t {\n\t \"@type\": \"WebPage\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts\",\n\t \"name\": \"The best ways to format ArcGIS Pro tables in layouts\",\n\t \"isPartOf\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\"\n\t },\n\t \"datePublished\": \"2021-09-07T20:11:44+00:00\",\n\t \"description\": \"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.\",\n\t \"breadcrumb\": {\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts#breadcrumb\"\n\t },\n\t \"inLanguage\": \"en-US\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"ReadAction\",\n\t \"target\": [\n\t \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts\"\n\t ]\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"BreadcrumbList\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts#breadcrumb\",\n\t \"itemListElement\": [\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 1,\n\t \"name\": \"Home\",\n\t \"item\": \"https:\/\/www.esri.com\/about\/newsroom\"\n\t },\n\t {\n\t \"@type\": \"ListItem\",\n\t \"position\": 2,\n\t \"name\": \"Ten Tips for Tables in Layouts\"\n\t }\n\t ]\n\t },\n\t {\n\t \"@type\": \"WebSite\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#website\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/\",\n\t \"name\": \"Esri\",\n\t \"description\": \"Esri Newsroom\",\n\t \"potentialAction\": [\n\t {\n\t \"@type\": \"SearchAction\",\n\t \"target\": {\n\t \"@type\": \"EntryPoint\",\n\t \"urlTemplate\": \"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}\"\n\t },\n\t \"query-input\": {\n\t \"@type\": \"PropertyValueSpecification\",\n\t \"valueRequired\": true,\n\t \"valueName\": \"search_term_string\"\n\t }\n\t }\n\t ],\n\t \"inLanguage\": \"en-US\"\n\t },\n\t {\n\t \"@type\": \"Person\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/82e5143bcdebadf8fd64d84e503ca468\",\n\t \"name\": \"Monica Pratt\",\n\t \"image\": {\n\t \"@type\": \"ImageObject\",\n\t \"inLanguage\": \"en-US\",\n\t \"@id\": \"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/\",\n\t \"url\": \"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg\",\n\t \"contentUrl\": \"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg\",\n\t \"caption\": \"Monica Pratt\"\n\t },\n\t \"description\": \"Monica Pratt is the founding and current editor of ArcUser magazine, the executive editor of ArcNews magazine, the editor of Esri Globe and head of the Publications team at Esri. She has been writing on technology topics, specializing in GIS, for more than 30 years. Before joining Esri in 1997, she worked for newspapers and in the financial industry.\",\n\t \"sameAs\": [\n\t \"https:\/\/x.com\/ArcUser\"\n\t ],\n\t \"url\": \"\"\n\t }\n\t ]\n\t}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The best ways to format ArcGIS Pro tables in layouts","description":"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.","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.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts","og_locale":"en_US","og_type":"article","og_title":"Ten Tips for Tables in Layouts","og_description":"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.","og_url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts","og_site_name":"Esri","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","og_image":[{"url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2021\/08\/10tips_banner.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@Esri","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts","url":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts","name":"The best ways to format ArcGIS Pro tables in layouts","isPartOf":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/#website"},"datePublished":"2021-09-07T20:11:44+00:00","description":"Read this article and learn how to format and organize tables in ArcGIS Pro layouts using these ten techniques.","breadcrumb":{"@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/about\/newsroom\/arcuser\/ten-tips-for-tables-in-layouts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/about\/newsroom"},{"@type":"ListItem","position":2,"name":"Ten Tips for Tables in Layouts"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/about\/newsroom\/#website","url":"https:\/\/www.esri.com\/about\/newsroom\/","name":"Esri","description":"Esri Newsroom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/about\/newsroom\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/82e5143bcdebadf8fd64d84e503ca468","name":"Monica Pratt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/about\/newsroom\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg","contentUrl":"https:\/\/www.esri.com\/about\/newsroom\/app\/uploads\/2018\/08\/MonicaMug_agol2.jpg","caption":"Monica Pratt"},"description":"Monica Pratt is the founding and current editor of ArcUser magazine, the executive editor of ArcNews magazine, the editor of Esri Globe and head of the Publications team at Esri. She has been writing on technology topics, specializing in GIS, for more than 30 years. Before joining Esri in 1997, she worked for newspapers and in the financial industry.","sameAs":["https:\/\/x.com\/ArcUser"],"url":""}]}},"sort_order":"17","_links":{"self":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/454262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser"}],"about":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/types\/arcuser"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/users\/1031"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser\/454262\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/media?parent=454262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/categories?post=454262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/tags?post=454262"},{"taxonomy":"arcuser_issues","embeddable":true,"href":"https:\/\/www.esri.com\/about\/newsroom\/wp-json\/wp\/v2\/arcuser_issues?post=454262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}