It will show additional options on the right.
You can hold the control key and then select these cells to make sure all cells are selected (even if these are non-contiguous) Suppose you have a list as shown below and you want to show the category as normal text but the item in the category with a little indent to the right (as shown in the image below).īut when you enter these values in Google Sheets, you end up with a list with the same indentation.īelow are the steps to add indentation the items (while keeping the Category text as is):
And in this method, that’s what we are going to do. While mostly this is used for formatting numbers, we can also give it some custom format.
All these are just different formats while the value in the cell remains the same. For example, you can have the value 44196 be displayed as 44196.00 or 44,196 or. Remember the number formatting only changes the format of the text/value in the cell, and not the value itself.
