configure cells in column to automatically create new line when pressing Enter

[Wallaby]

Hi,

I am using Excel 365 as a CRM (example attached). For each client record, I will have several interactions, which I will record in the Notes field. There is 1 client record per row in the spreadsheet.

Currently I must click Alt+Enter to add a row.

As multiple users will add information, I wish a new line to be automatically added in the Notes field when clicking Enter after each interaction recorded. The Notes field for each record is in Column N (in my attachment). I have highlighted (YELLOW) what I am trying to achieve.

Is this possible?

If so, is it possible to configure a bullet point to appear for each new line in the cell?

Thank you.

[AliGW]

Welcome to the forum.

The easiest way would be to select E2 to N3 and Insert | Table | tick My Table has Headers | OK.

Now you can use the TAB key to anter a new table row. It's one keypress - no different really to hitting ENTER. Otherwise you'd need VBA.

[Wallaby]

Thank you AliGW,

I am wishing to add a new line though (i.e. within the cell, and therefore within the row), rather than add a new row.

[Greg M]

Hi there,

See if the following code does what you need - it should be entered in the VBA CodeModule for the worksheet in question (rather than in a standard VBA CodeModule).

Please Login or Register  to view this content.

The highlighted value may be changed to suit your own needs.


Hope this helps - please let me know how you get on.

Regards,

Greg M