Excel offers a very interesting way to enter without changing cells. We can cater to this problem statement by using “Enter” and “Alt” keys. We can perform the below mentioned way to enter without changing cells in excel:
We’ll learn about this methodology step by step.
To do this yourself, please follow the steps described below;
Step 1 – Excel workbook with a text
– Open the desired Excel workbook containing a text to which a new line will be added
Step 2 – Using the Enter and Alt keys
– Now click in the cell where the text is present and press “Enter + Alt”. Now you may type some additional text to test the functionality, and hit Enter.
Step 3 – Entered without changing cells
– We can see that we have entered to a new line, added a text, without changing cells