{"id":123,"date":"2022-07-27T15:49:54","date_gmt":"2022-07-27T10:19:54","guid":{"rendered":"https:\/\/sheetstips.com\/?p=123"},"modified":"2022-07-29T12:07:38","modified_gmt":"2022-07-29T06:37:38","slug":"merge-cells-google-sheets","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/merge-cells-google-sheets\/","title":{"rendered":"How to Quickly Merge Cells in Google Sheets: Merge &#038; Unmerge Without Losing Data"},"content":{"rendered":"<p><strong>Google sheets Merge Function<\/strong> is one of the useful features which allows the user to Merge the Cells. One can make use of the <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/#extend-google-sheets-with-add-ons\" target=\"_blank\" rel=\"noopener\">Google Sheet Add-on function <\/a><\/strong>to merge the cells in one go. However, if you want to merge the cells manually, then you can use the options which are available under the &#8220;<strong>Format<\/strong>&#8221; option. On this page, we have explained all details on how to merge cells manually without losing data. Read on to find out more.<\/p>\n<h2>How to Merge Cells in Google Sheet?<\/h2>\n<p>Let&#8217;s consider the following example to merge cells on G-Sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-98 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/using-if-functions-in-google-sheets.jpg\" alt=\"merge cells in google sheets\" width=\"482\" height=\"483\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/using-if-functions-in-google-sheets.jpg 482w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/using-if-functions-in-google-sheets-300x300.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/using-if-functions-in-google-sheets-150x150.jpg 150w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/p>\n<p><strong>Steps to Merge Cells on Google Sheets:<\/strong><\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the Cells.<\/li>\n<li><strong>Step 2:<\/strong> Click on the &#8220;<strong>Format<\/strong>&#8221; option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-124 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"1069\" height=\"744\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets.jpg 1069w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-300x209.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1024x713.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-768x535.jpg 768w\" sizes=\"(max-width: 1069px) 100vw, 1069px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Select the &#8220;<strong>Merge Cells<\/strong>&#8221; and click on &#8220;<strong>Merge All<\/strong>&#8221; from the drop-down menu.<\/li>\n<li><strong>Step 4:<\/strong> A warning message &#8220;<em><strong>Merging cells will only preserve the top-leftmost value. Merge anyway?<\/strong><\/em>&#8221; will be shown. Click on &#8220;<strong>OK<\/strong>&#8220;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-125 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"1540\" height=\"650\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1.jpg 1540w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1-300x127.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1-1024x432.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1-768x324.jpg 768w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-1-1536x648.jpg 1536w\" sizes=\"(max-width: 1540px) 100vw, 1540px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> The cells will be merged.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-126 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-2.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"476\" height=\"497\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-2.jpg 476w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-2-287x300.jpg 287w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/p>\n<p><em>Note: If you click on &#8220;Merge All&#8221;, only the top-most value will be retained.<\/em><\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/highlight-duplicates-google-sheets\/\">How To Highlight Duplicates In Google Sheets?<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-indents-in-google-sheets\/\">How To Insert Indents in Google Sheets? \u2013 Know How to Tab Down in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/conditional-formatting-based-on-another-cell-value-in-google-sheets\/\">Conditional Formatting Based on Another Cell Value in Google Sheets<\/a><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"How to Quickly Merge Cells in Google Sheets (Horizontally, Vertically, Unmerge)\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/8DIKWsRYuGY?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h3>List of Options Available to Merge Cells on Google Sheets<\/h3>\n<p>On Google sheets, we have 3 options that help us to merge cells. The 3 different methods through which we can merge cells on Google Sheets are:<\/p>\n<p><strong>Merge All: <\/strong>This option merges all the selected cells into a single cell. Note that you can only combine contiguous cells. You will not be able to use merge options if you have non-contiguous cells.\u00a0<strong><br \/>\n<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-127\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-All-1.png\" alt=\"Merge-Cells-in-Google-Sheets-Merge-All\" width=\"1145\" height=\"155\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-All-1.png 1145w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-All-1-300x41.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-All-1-1024x139.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-All-1-768x104.png 768w\" sizes=\"(max-width: 1145px) 100vw, 1145px\" \/><\/p>\n<p><strong>Merge Horizontally: <\/strong>This would merge all the cells into a horizontal cell. Even if you select multiple rows of cells, this function only merges the cells horizontally.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-128\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Horizontal.png\" alt=\"Merge-Cells-in-Google-Sheets-Merge-Horizontal\" width=\"1143\" height=\"154\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Horizontal.png 1143w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Horizontal-300x40.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Horizontal-1024x138.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Horizontal-768x103.png 768w\" sizes=\"(max-width: 1143px) 100vw, 1143px\" \/><\/p>\n<p><strong>Merge Vertically: <\/strong>This would merge all the cells into the vertical cell. Even if you select multiple columns of cells, this function only merges cells into a vertical cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-129\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Vertical.png\" alt=\"Merge-Cells-in-Google-Sheets-Merge-Vertical\" width=\"1141\" height=\"151\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Vertical.png 1141w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Vertical-300x40.png 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Vertical-1024x136.png 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/Merge-Cells-in-Google-Sheets-Merge-Vertical-768x102.png 768w\" sizes=\"(max-width: 1141px) 100vw, 1141px\" \/><\/p>\n<h3>How to Unmerge Cells in Google Sheets?<\/h3>\n<p>Follow the steps as listed below to unmerge cells in Google Sheets:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the Merged cells on the Google sheet.<\/li>\n<li><strong>Step 2:<\/strong> Click on the &#8220;<strong>Format<\/strong>&#8221; option.<\/li>\n<li><strong>Step 3:<\/strong> Select the &#8220;<strong>Merge Cells<\/strong>&#8221; and hit on &#8220;<strong>Unmerge<\/strong>&#8220;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-130 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/unmerge-cells-on-google-sheet.jpg\" alt=\"unmerge cells on google sheet\" width=\"964\" height=\"836\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/unmerge-cells-on-google-sheet.jpg 964w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/unmerge-cells-on-google-sheet-300x260.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/unmerge-cells-on-google-sheet-768x666.jpg 768w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> The cells will be unmerged.<\/li>\n<\/ul>\n<h3>What is the Shortcut for Merge Cells in Google Sheets?<\/h3>\n<p>Follow the steps listed below to merge cells in google sheets in a shortcut way.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Move to the Google sheets menu bar.<\/li>\n<li><strong>Step 2:<\/strong> You will see a list of Google sheet shortcuts.<\/li>\n<li><strong>Step 3:<\/strong> Click on the Merge Icon. Refer to the image below.<\/li>\n<li><strong>Step 4:<\/strong> As soon you click on the &#8220;<strong>Merge<\/strong>&#8221; icon, you will find 4 options. Select your desired option.<\/li>\n<li><strong>Step 5:<\/strong> Click on &#8220;<strong>Enter<\/strong>&#8220;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-131 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-3.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"1456\" height=\"675\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-3.jpg 1456w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-3-300x139.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-3-1024x475.jpg 1024w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-3-768x356.jpg 768w\" sizes=\"(max-width: 1456px) 100vw, 1456px\" \/><\/p>\n<h3>Merge Cells in Google Sheets without Losing Data<\/h3>\n<p>Let&#8217;s consider the following example. Here I want to merge the employee ID against the employee department under the department ID.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-132 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-4.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"760\" height=\"552\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-4.jpg 760w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-4-300x218.jpg 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/p>\n<p>Follow the steps listed below to merge cells in Google Sheets without losing data.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Select the cell where you would like to merge the column without losing data.<\/li>\n<li><strong>Step 2:<\/strong> Enter the formula in the selected column as &#8220;<strong>=CONCATENATE(Cell No,\u201d \u201c,Cell No)&#8221;<\/strong><\/li>\n<li><strong>Step 3:<\/strong> Now drag down the cursor and the formula will be applied for all the cells.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-133\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-5.jpg\" alt=\"How to Quickly Merge Cells in Google Sheets\" width=\"856\" height=\"630\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-5.jpg 856w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-5-300x221.jpg 300w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/07\/How-to-Quickly-Merge-Cells-in-Google-Sheets-5-768x565.jpg 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/p>\n<h3>Important Formulas to Merge Cells on Google Sheets<\/h3>\n<ul>\n<li>To merge rows without space and without losing data: &#8220;<strong>=CONCATENATE(Cell No,Cell No,Cell No)&#8221;<\/strong><\/li>\n<li>To merge rows with space and without losing data: &#8220;<strong>=CONCATENATE(Cell No,\u201d \u201c,Cell No,\u201d \u201c,Cell No)&#8221;<\/strong><\/li>\n<li>To merge rows without losing data separated by a comma: &#8220;<strong>=CONCATENATE(Cell No,\u201d, \u201c,Cell No,\u201d, \u201c,Cell No)&#8221;<\/strong><\/li>\n<\/ul>\n<h3>FAQs on Merge Cells on Google Sheets<\/h3>\n<p><strong>Question 1.<\/strong><br \/>\nHow do you merge cells without losing data?<\/p>\n<p><strong>Answer:<\/strong><br \/>\nTo merge cells without losing data, one will have to use the &#8220;CONCATENATE&#8221; option.<\/p>\n<p><strong>Question 2.<\/strong><br \/>\nWhat is the message &#8220;Merging cells will only preserve the top leftmost value. Merge anyway?&#8221; shown on google sheets.<\/p>\n<p><strong>Answer:<\/strong><br \/>\nWhen you merge 2 or more cells on the Google sheet, the sheet will retain only the topmost left value of a cell in the Google sheet. To confirm this, the sheets show this message.<\/p>\n<p><iframe loading=\"lazy\" title=\"Combine Cell Contents from Two Different Columns in Google Sheets\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/4sjlbj_tTZg?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><strong>Question 3.<\/strong><br \/>\nCan I merge two cells and keep both data?<\/p>\n<p><strong>Answer:<\/strong><br \/>\nYes, with the help of the &#8220;<strong>CONCATENATE<\/strong>&#8221; option, one can merge two cells and keep both the data in one cell.<br \/>\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"How do you merge cells without losing data?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To merge cells without losing data, one will have to use the \\\"CONCATENATE\\\" option.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the message \"Merging cells will only preserve the top leftmost value. Merge anyway?\" shown on google sheets.\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"When you merge 2 or more cells on the Google sheet, the sheet will retain only the topmost left value of a cell in the Google sheet. To confirm this, the sheets show this message.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Can I merge two cells and keep both data?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Yes, with the help of the \\\"CONCATENATE\\\" option, one can merge two cells and keep both the data in one cell.\"\n    }\n  }]\n}\n<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google sheets Merge Function is one of the useful features which allows the user to Merge the Cells. One can make use of the Google Sheet Add-on function to merge the cells in one go. However, if you want to merge the cells manually, then you can use the options which are available under the &#8230; <a title=\"How to Quickly Merge Cells in Google Sheets: Merge &#038; Unmerge Without Losing Data\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/merge-cells-google-sheets\/\" aria-label=\"More on How to Quickly Merge Cells in Google Sheets: Merge &#038; Unmerge Without Losing Data\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[55,54],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":375,"url":"https:\/\/sheetstips.com\/concatenate-in-google-sheets\/","url_meta":{"origin":123,"position":0},"title":"Concatenate in Google Sheets: Concatenate Multiple Cells using Separator, Comma","author":"Varsha","date":"May 19, 2022","format":false,"excerpt":"Concatenate in Google Sheets: Concatenate is a formula that can be used to combine data from multiple data cells into a single cell. With the help of concatenating formula, we can combine multiple cells with separator, comma and much more options in Google Spreadsheet. In this article, let's understand how\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"Concatenate in Google Sheets3","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/Concatenate-in-Google-Sheets3.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":564,"url":"https:\/\/sheetstips.com\/combine-formula-and-text-in-google-sheets\/","url_meta":{"origin":123,"position":1},"title":"How to Combine Formula and Text in Google Sheets: 2 Easy Methods","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"In Google spreadsheets, combining text and numbers is common. You may need to combine text values with formula results in a range of situations. For example, if you would like to combine text and formula values from 2 different cells into a single cell, then you will have to make\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"combine-formula-and-text-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/combine-formula-and-text-in-google-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":192,"url":"https:\/\/sheetstips.com\/how-to-insert-bullets-in-google-sheets\/","url_meta":{"origin":123,"position":2},"title":"How to Insert Bullets in Google Sheets: Adding Bullets in MAC, IOS, Android","author":"Varsha","date":"May 21, 2022","format":false,"excerpt":"Adding Bullets in Google Sheets: Bullets are usually a type of symbol used to highlight the items in the list. Though Google sheets come with hundreds of features, the Bullets or numbering feature is missing out. Thus one needs to add the bullets manually in order to insert bullets in\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how to add bullets in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/07\/how-to-add-bullets-in-google-sheets-5.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":386,"url":"https:\/\/sheetstips.com\/split-text-to-columns-google-sheets\/","url_meta":{"origin":123,"position":3},"title":"How to Split Text to Columns in Google Sheets: Split Cell Horizontally\/Vertically","author":"Varsha","date":"May 19, 2022","format":false,"excerpt":"Split Text to Columns: When working with a huge dataset in Google Sheets, it's common to squish the data. Split text to columns is one of the most useful features which was recently added in Google Sheets, that helps to split the data into columns. You can split data in\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"split text to columns using formula","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/split-text-to-columns-using-formula.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2801,"url":"https:\/\/sheetstips.com\/python-adjusting-rows-and-columns-of-an-excel-file-using-openpyxl-module\/","url_meta":{"origin":123,"position":4},"title":"How to Adjust Rows and Columns of an Excel File using openpyxl Module in Python?","author":"David","date":"June 1, 2022","format":false,"excerpt":"Python is a powerful programmable language that allows us to perform various operations on Excel, from simple to complicated. Adjusting rows and columns in an Excel file just takes seconds. But we can also adjust the rows and columns in Excel just by using the\u00a0openpyxl module in Python. Surprised? Well,\u2026","rel":"","context":"In &quot;MS Excel&quot;","block_context":{"text":"MS Excel","link":"https:\/\/sheetstips.com\/category\/ms-excel\/"},"img":{"alt_text":"How to Adjust Rows and Columns of an Excel File using openpyxl Module in Python","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/05\/How-to-Adjust-Rows-and-Columns-of-an-Excel-File-using-openpyxl-Module-in-Python.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":278,"url":"https:\/\/sheetstips.com\/dependent-drop-list-google-sheets\/","url_meta":{"origin":123,"position":5},"title":"How to Create a Dependent Drop Down List in Google Sheets: Multiple Drop Down List","author":"Varsha","date":"May 21, 2022","format":false,"excerpt":"Dependent Drop Down List in Google Sheets: Usually a drop down list in Google Sheet is used to create a list of options where users can choose from. Drop down list is one of the most helpful functions in G-Suite since it helps us to save more time by avoiding\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"How to Create a Dependent Drop Down List in Google Sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/How-to-Create-a-Dependent-Drop-Down-List-in-Google-Sheets-8.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/123"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":2,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"predecessor-version":[{"id":4280,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/123\/revisions\/4280"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}