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

creating new lines excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating new lines on excel, within the same cell

Creating new lines on excel, within the same cell

ResolvedVersion 365

Dimple has attended:
Excel Intermediate course

Creating new lines on excel, within the same cell

hi there,

im creating an excel database for a risk register. in one cell, I am writing several actions such as:

1. Additional posts have been agreed 2. Increased communications resource with 3. To contunually review our ways of working 4. Adopting MVP

what I want is for the format to look tidy and each thing marked 1,2,3,4 to be on separate lines but within the same cell (i.e. I don't want a different cell for each thing). so it should look like below, but in the SAME CELL:


1. Additional posts have been agreed
2. Increased communications resource with
3. To contunually review our ways of working
4. Adopting MVP

thanks in advance

RE: Creating new lines on excel, within the same cell

Hi Dimple

Thank you for using the forum

Pressing Alt + Enter should create a line break at the point where your mouse cursor is inside the cell.

Hope this helps

Kind regards

Wendy

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

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.