{"id":9154,"date":"2022-03-04T14:55:58","date_gmt":"2022-03-04T14:55:58","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=9154"},"modified":"2024-03-28T10:35:43","modified_gmt":"2024-03-28T10:35:43","slug":"insert-a-tab-in-excel-cell","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/","title":{"rendered":"Insert a Tab in Excel Cell"},"content":{"rendered":"\n
Insert-a-Tab-in-Excel-Cell<\/a>Download File<\/a><\/div>\n\n\n\n

As already mentioned, Excel is a great tool for automatization, numbers, and reporting. It can sometimes be stressful to present the data the way we want. One of the things that can get in our way is to indent our data by inserting a tab in our cell.<\/p>\n\n\n\n

To show how to do this, and how to show the data in a better way by inserting a tab in our cell, we will use the example below.<\/p>\n\n\n\n

Insert a Tab in Excel Cell<\/h2>\n\n\n\n

Although it might seem pretty easy to do it, this task- inserting a tab, is not so simple. You cannot simply go into a cell and click Tab<\/strong>. By doing this, you would just position yourself into another cell.<\/p>\n\n\n\n

In a Word file, all you need to do to indent your text is click on the Tab button<\/strong> on your keyboard.<\/p>\n\n\n\n

In Excel, you also have an option for indenting. Suppose that we have the following text in Excel:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Now we want our text to be indented to the right. To do so, we need to click on the cell A2<\/strong>, go to the Home tab<\/strong>, find the Alignment section<\/strong>, and click on the Increase Indent<\/a> icon<\/strong>, as shown in the picture below:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

This is the result we get when we click on it:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

When we click it more times- three of four, we get the following results:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Using the indenting option<\/strong> limits us to the exact number of spaces that are being added from the beginning of our cell to our text. We can also define the spaces in the tab manually.<\/p>\n\n\n\n

We will simply write \u201cDifferent text\u201d<\/strong> in cell A4<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Now, to move this text to the right, we need to click on the cell, go to Home >> Alignment<\/strong>, and then on the Alignment Settings<\/strong> in the bottom right corner:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

Once we click on it we will notice that we are on the Alignment tab<\/strong>:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

We will choose Left (Indent)<\/strong> on a dropdown beneath Horizontal<\/strong>: and choose the indent we want (in our case we will input number 4<\/strong>). This is the result we got:<\/p>\n\n\n\n

\"Graphical<\/figure>\n\n\n\n

It is important to note that we cannot use decimals when defining indenting, i.e. we cannot use 3.5 or 4.5<\/strong>, for example.<\/p>\n\n\n\n

Again, there is no simple way to insert a tab in a certain cell in Excel. To produce a tab in Excel, we can use the function CHAR(9)<\/strong>. However, it does nothing for us.<\/p>\n\n\n\n

Besides indenting, we can also use space and concatenating options. For example, in a formula like this:<\/p>\n\n\n\n

=\" \"&\"Text with indenting\"<\/code><\/pre>\n\n\n\n

When we insert this in cell A6<\/strong>, our text looks like this:<\/p>\n\n\n\n

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

As already mentioned, Excel is a great tool for automatization, numbers, and reporting. It can sometimes be stressful to present the data the…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nInsert a Tab in Excel Cell<\/title>\n<meta name=\"description\" content=\"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insert a Tab in Excel Cell\" \/>\n<meta property=\"og:description\" content=\"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-04T14:55:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T10:35:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Insert a Tab in Excel Cell\",\"datePublished\":\"2022-03-04T14:55:58+00:00\",\"dateModified\":\"2024-03-28T10:35:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\"},\"wordCount\":444,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\",\"name\":\"Insert a Tab in Excel Cell\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png\",\"datePublished\":\"2022-03-04T14:55:58+00:00\",\"dateModified\":\"2024-03-28T10:35:43+00:00\",\"description\":\"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Insert a Tab in Excel Cell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Insert a Tab in Excel Cell","description":"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.","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:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/","og_locale":"en_US","og_type":"article","og_title":"Insert a Tab in Excel Cell","og_description":"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.","og_url":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/","article_published_time":"2022-03-04T14:55:58+00:00","article_modified_time":"2024-03-28T10:35:43+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Insert a Tab in Excel Cell","datePublished":"2022-03-04T14:55:58+00:00","dateModified":"2024-03-28T10:35:43+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/"},"wordCount":444,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/","url":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/","name":"Insert a Tab in Excel Cell","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png","datePublished":"2022-03-04T14:55:58+00:00","dateModified":"2024-03-28T10:35:43+00:00","description":"Learn how to insert a tab in an Excel cell to present your data in a better way. Follow our tutorial with step-by-step instructions and screenshots.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/03\/graphical-user-interface-text-application-descr-4.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/insert-a-tab-in-excel-cell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Insert a Tab in Excel Cell"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9154"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=9154"}],"version-history":[{"count":6,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9154\/revisions"}],"predecessor-version":[{"id":17357,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/9154\/revisions\/17357"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=9154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=9154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=9154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}