Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
It's a fundamental feature that I need in my financial work but I can't seem to get this working in Google Sheets, or it doesn't support it.
I've also looked into Zoho Sheet, but they also don't support this.
Can it be done in Google Sheets, or should I look to another web app?
You can type either Alt+0160 or Alt+255 to insert non-breaking spaces to create indentation.
You can indent values in cells using EditGrid which free.
It provides with a whole range of Excel like functionality.
Cut-and-paste, sorting, charts, auto-fill, cell border, number formatting, cell formatting, import, export, print, find, undo, redo, freeze pane, text overflow, auto-fit row/column size, word warp, cell comments, 500+ functions ... You name it, EditGrid has it.
EditGrid can import/export your spreadsheets from/to many popular spreadsheet file formats, including Microsoft Excel (.xls), OpenDocument (.ods), OpenOffice.org (.sxc), CSV (.csv), and many others.
You can try out an online demo of EditGrid here
You can use a formula to create an indentation.
=CONCAT(REPT(CHAR(160),3),"test")
The white space (CHAR(160)) is repeated 3 times and combined with the text test via the CONCAT formula.
Use this custom function in a Google script attached to the spreadsheet:
function indent(_txt, _spaces) {
var txt = (!_txt) ? "Test text" : _txt;
var spaces = (!_spaces) ? 2 : _spaces;
var space = " ";
var f = '';
for (var i=0; i<spaces; i++) {
f += space;
}
f += txt;
return f;
}
IMPORTANT: The space that you enter in the var space = " " line should be a SHIFT-ALT/OPTION-SPACE from Alex and Hannah above.
Use the function in the spreadsheet like this: =indent("Indent me", 2)
On Google Doc Spreadsheets, you can do this by holding down Shift + Alt (Option) + Space.
