{"id":1073,"date":"2012-05-27T20:59:50","date_gmt":"2012-05-27T18:59:50","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=1073"},"modified":"2022-04-03T09:19:53","modified_gmt":"2022-04-03T07:19:53","slug":"chytra-tabulka-v-excelu","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/chytra-tabulka-v-excelu\/","title":{"rendered":"Format as “smart” table in Excel"},"content":{"rendered":"

<\/p>\n

\"\"On my trainings I usually show the “smart table” as\u00a0a bonus topic, the students are amazed by the options of this\u00a0tool and collectively agree that they do not want to work with another table\u00a0anymore. Indeed it makes easier\u00a0both formatting and filtering, subtotals, and more. Let’s see at least some of the tweaks, others I will be happy to demonstrate directly\u00a0on the trainings.\u00a0If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n

When creating tables, users spend a lot of time by changing\u00a0its\u00a0graphic design and preparation for calculation formulas, filters or setting freezing panes\u00a0with headlines. This\u00a0tool, which can be unofficially called “smart table”, will save a lot of time.<\/p>\n

The tool is activated by placing the mouse anywhere in the prepared table with data, since\u00a0Excel 2007\/2010 we\u00a0can find it on the Insert tab > Table<\/strong>. This command is apparently somewhat perplexing for Excel because it is itself only a one large table, what sense\u00a0does it make\u00a0to insert a new table\u00a0into another table? The name is misleading, but rather should therefore be called “smart table” or according to the official terminology “table\u00a0of the\u00a0list form” After confirming the dialog with range location, it is\u00a0ready, as shown below.\"\"<\/a><\/p>\n

When selecting any cell inside the table now, it\u00a0activates a new tab\u00a0at the end of the Ribbon called Design<\/strong>. It contains tools for facilitating effective work with the smart table. We can describe some\u00a0of them:<\/p>\n