Question

write step to split the cell content in multiple lines when the content are bigger than column width?

Answer 1

Sometimes, when the text in the columns is so much that the column would look wider than the other columns, which results in a lot of wasted space. Therefore, it is advisable to split the cell content into multiple lines within a single cell.

There are 2 ways to do this:

Method 1:

(i) Select the cells where the content should appear.

(ii) Enter the first line of the data

(iii) Press ALT + ENTER

(iv) Enter the second line

(v) Press ALT + ENTER, if there are any more additional lines to follow.

When the above method is used, the text will be wrapped in the Excel and the row height of each cell in which the ALT + ENTER command is used will also be adjusted.

Another method is to just select the cells in which the text should be wrapped, go to ‘Format’ option in the menu, select ‘Cells’, and then click on the ‘Alignment’ tab, enable the ‘Wrap Text’ option and click ‘OK’.

Answer 2

When the contents are bigger than the column width it is better to split the cell content in multiple lines. This can be done in two ways.

Method 1

i. Select the cells in which the contents should appear in multiple lines

ii. Enter the first line of the data

iii. Hold down the Alt button and press Enter to start a new line

Method 2

i. Select the cells in which the contents should appear in multiple lines

ii. Click on 'Format' in the Menu

iii. Select 'Cells'

iv. Click on the 'Alignment' tab

v. Enable the 'Wrap Text' option

vi. Click 'OK'