[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Despite being a spreadsheet program, Google Sheets provides many features related to text formatting<\/a>. However, you may have noticed it lacks some basic features related to text, such as the ability to insert bullet points or use the tab key to indent contents within your cells. Fortunately, while there\u2019s no button or menu option, there are multiple ways to do both.<\/p>\n In this guide, you will learn about four different methods you can use to indent the contents of your cells. The first method uses the copy & paste technique, which allows you to get tab spacing from other programs. The second method uses the custom number format feature to display an indentation in your cell contents. The third method uses the always useful CHAR function to indent contents with a formula. Finally, the fourth method uses a helper column to give the appearance of indentation without changing the cell\u2019s contents.<\/p>\n [\/et_pb_text][et_pb_text module_id=”can-you-tab-within-a-cell-to-indent-in-g” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Unfortunately, you can\u2019t use the tab key to indent cell contents, as you will simply move to the next cell. However, you can type multiple spaces before your text or copy a tab space from another program, such as TextPad or Google Docs, and paste it directly into your cell.<\/p>\n Select the cells to which you want to apply the indentation and go to Format > Number > Custom number format. In the text box at the top, type in the spacing you want to indent by, followed by the at symbol (@). Click \u2018Apply\u2019 to save and apply the indentation.<\/p>\n 1.<\/strong> Select the cells to which you want to add the indentation and go to Format > Number > Custom number format.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-format-number-custom-menu.webp” alt=”How to indent in Google Sheets \u2014 Format menu open at Number with Custom number format at the bottom” title_text=”Format menu open at Number with Custom number format at the bottom” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In the text box, add as many spaces as you need to achieve the indentation you want, followed by the at symbol (@). Pasting a tab space in this text box won\u2019t work, so you must use the space key.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-custom-number-format-dialog.webp” alt=”Indent in Google Sheets \u2014 Custom number formats dialog with spaces typed before the @ symbol” title_text=”Custom number formats dialog with spaces typed before the @ symbol” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Click \u2018Apply\u2019 to save and apply the custom number format.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-custom-format-result.webp” alt=”Indent in Google Sheets \u2014 list items in column A indented by the custom number format” title_text=”List items in column A indented by the custom number format” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”indent-in-google-sheets-with-a-formula” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In Google Sheets, you can indent the cell\u2019s contents by using the CHAR function in your formulas. CHAR(32) will insert a space within your formula, so if you want to indent the contents, you can add as many spaces as you need before the values or calculations you want to indent.<\/p>\n 1.<\/strong> In an empty cell, type the equal sign followed by CHAR(32). If you want to use more than one space character, you can concatenate them<\/a> using the ampersand (&), as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-char-32-formula.webp” alt=”Indent in Google Sheets with a formula \u2014 CHAR(32) joined three times with ampersands in cell E2″ title_text=”CHAR(32) joined three times with ampersands in cell E2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> After the last ampersand (&), type the text between quotes, the value, or the calculation you want to use. Alternatively, select the cell with the contents, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-char-32-add-cell.webp” alt=”Indent in Google Sheets with a formula \u2014 cell D2 added after the CHAR(32) spaces in the formula” title_text=”Cell D2 added after the CHAR(32) spaces in the formula” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Press \u2018Enter\u2019 to see the result. Grab the fill handle and drag it down<\/a> to the last item.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-formula-result.webp” alt=”Indent in Google Sheets with a formula \u2014 indented list filled down column E under My List (Formula)” title_text=”Indented list filled down column E under My List (Formula)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”indent-in-google-sheets-with-a-helper-co” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This last method won\u2019t add the indentation within the cells but simply use a helper column to give the appearance of indentation. In other words, you can make it look like the entire column\u2019s contents are indented.<\/p>\n 1.<\/strong> Insert a column to the left of the one you want to indent.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-insert-column-left.webp” alt=”Indent in Google Sheets with a helper column \u2014 Insert menu at Columns with Insert 1 column left” title_text=”Insert menu at Columns with Insert 1 column left” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Resize the helper column to the width by which you want to indent.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/indent-google-sheets-resize-helper-column.webp” alt=”Indent in Google Sheets with a helper column \u2014 narrow empty column G resized next to the list” title_text=”Narrow empty column G resized next to the list” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nCan you tab within a cell to indent in Google Sheets?<\/h2>\n
Indent in Google Sheets with a custom number format<\/h3>\n
Indent in Google Sheets with a formula<\/h2>\n
Indent in Google Sheets with a helper column<\/h2>\n