Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

How do indent spreadsheet cells in Google Docs? It's a fundamental feature that I need in my financial work but I can't seem to get this working in Google Docs, 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 Docs? Or should I look to another web app?

share|improve this question
1  
Do you have a screenshot of an app that shows indention? –  kzh Jun 28 '11 at 15:02
    
Gnumeric does this: Gnumeric screenshot –  Belisama May 24 '12 at 0:23

5 Answers 5

You can type either Alt+0160 or Alt+255 to insert non-breaking spaces to create indentation.

share|improve this answer

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

share|improve this answer

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)

share|improve this answer

You can use a formula to create an indentation.

Formula

=CONCAT(REPT(CHAR(160),3),"test")

Explained

The white space (CHAR(160)) is repeated 3 times and combined with the text test via the CONCAT formula.

Screenshot

enter image description here

share|improve this answer

On Google Doc Spreadsheets, you can do this by holding down Shift + Alt (Option) + Space.

share|improve this answer
    
Couldn't get this to work. Should one be in "edit the cell" mode or "move around the screen" mode? –  Belisama May 24 '12 at 0:25
    
Could not get this to work either. –  OnenOnlyWalter Oct 21 '12 at 22:12
    
Could not get this to work either. –  Jacob Jan Tuinstra Apr 14 at 17:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.