Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

columns

ResolvedVersion 2007

Peter has attended:
Excel Introduction course

Columns

how do I format so that multi text drops vertically within column rather than continues horizontally?

RE: columns

Hi Peter

Thank you for your question and welcome to the forum.

I think you are referring to text wrapping, which is where you can get text to go onto more than one line inside a cell.

There are two ways to do this:

1. If you have already entered the information into the cell, then go to the Home ribbon and click the Wrap Text button within the Alignment group of buttons. You may then need to adjust the width and height of the column and row that the cell is in so that the text goes onto more than one line.

2. When you are entering the text into a cell, press ALT + Enter to start a new line in the same cell.

I hope this helps.
Amanda

Excel tip:

Adding cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.