![]() The indent will now be applied to the selected cells: Removing Indenting The menu option shows the format definition you typed, which will look like an at sign, and a sample of what a cell looks like formatted with it, which will be 1234.56 since the indent doesn’t show in the menu option. Scroll down to almost the bottom of the Number submenu and you’ll see a new option for the custom format you just created. Open the Format menu and then select the Number submenu Step 3 Select the additional cells you want to assign formatting to Step 2 Now that you’ve defined the indent formatting, it’s easy to apply to additional cells as needed. Step 5Ĭlick Apply, and you’ll see the data in the selected cells indent: Assigning Indent Formatting to Additional Cells The at sign is a placeholder for text, telling the spreadsheet to display the content of the cell after the four spaces. If you need more or less indenting, adjust the number of spaces. This will indent your text by four spaces. In the window that appears, type four spaces followed by an at sign into the Custom Number Format field. ![]() Step 3įrom the Custom Formats submenu, select Custom Number Format: Step 4 Scroll down to the bottom of the Number submenu and select the More Formats submenu. Open the Format menu and select the Number submenu. You can always apply the indenting number format to additional cells later Step 2 We can get around this by creating custom number formatting and applying it to the cells we want to indent.įollow these steps to create a custom number format that indents your cells: Step 1ĭon’t worry if you don’t get them all now. Unfortunately, in Google Sheets there’s no built-in indenting tool like there is in other applications. Notice how it’s very hard to read what is a list item and what is a department.Īdding a simple indent before each list item would make things much clearer Adding Indents with Number Formatting The screenshot below shows a grocery list with items categorized by department. Indenting text in Google Sheets can help visually break up the spreadsheet so it’s easier to read and understand.įor example, if you have a list that contains categories, indenting list items can set them apart from the category headings and make the list easier to read. ![]() Assigning Indent Formatting to Additional Cells. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |