indent text

  • Thread starter Thread starter need help
  • Start date Start date
N

need help

Does anyone know how to indent text in a cell, but just a
portion of the text, and not the whole cell?
any help would be appreciated
e.g. want it to look like this

Why would microsoft excel create this problem?
knfkbnfklbfklbflkfblkfblfk
mblkbljbljbvljvljvjlvjlvl
 
Assuming you have used ALT+ENTER to get your data in a single cell as show, then
just add a couple of spaces to the start of lines 2 and 3. Don't forget, Excel
is a spreadsheet, not a wordprocessor, so it's not going to do everything that
Word can, and vice versa.
 
need

Type in the first line then hit ALT + ENTER to create a line break.

Then type in 5 spaces then the next line of text and ALT + ENTER

Type in 5 spaces and next line of text and ENTER.

Set the row and column to "Autofit" and the cell to "wrap text".

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Nested Functions - Formula Not Working 0
What's the deal with cheap "AMD ONLY" RAM from eBay? 13
bullet in excell with indent 1
I want to line up wrap around text within cell by tabbing over? 3
The future of gaming is NOT Cloud-based! 14
Reducing the blank space around text in Excel 2007 12
How to make body text indentation follow heading indentation? 1
hanging indent in a cell 2

Back
Top