How to Enter in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Enter in Excel



In this tutorial, you will learn how to enter in excel. This understanding of how to start a new line in excel cell is often needed if you have text data. The practice of this knowledge can make your text much neater.


Why do We Need to Understand How to Enter New Line in Excel?


In processing data on spreadsheets, especially the one with string form, sometimes we need to separate its content into several lines. This is needed for various purposes. Usually, we do it to make the text looks more organized.

If we don’t understand how to do it, then the text can only be shown in one line. This isn’t good because the writing will seem to be very long. Too long text in our spreadsheet will be cut if we want to print it. Besides, the data processing that you might want to do with the text data might become harder to do.

As an example of this need in our work, imagine we are creating a letter template for our company. This template is created in excel so it is easier to combine its content with the saved data in our file. A letter is a document that has a lot of text as its content. If we can only show the letter’s content in one line, then it will be very bad. The letter’s template form will look disorganized and not ideal to be sent.

If you want to easily give new lines for your writing, then you need to understand how to enter in excel. By using the understanding of this matter, then it will be easier to process text data in your spreadsheet file. This is very useful especially if you often make documents in your spreadsheet file.


What is How to Enter in Excel?


How to enter in excel is a spreadsheet function with the usage objective to create a new line in your text data. This function is often needed to organize the form of text that you have in your spreadsheet file.


How to Enter on Excel?


The following will explain two methods of how to enter in excel. It is better for you to understand both so you can use each of them as you need.


Method 1: Wrap Text

  1. Write your writing in a cell

    How to Copy Sheet in Excel - Screenshot of Step 1-1

  2. Highlight the cell

    How to Copy Sheet in Excel - Screenshot of Step 1-2

  3. Click wrap text in the Home tab

    How to Copy Sheet in Excel - Screenshot of Step 1-3

  4. Done! The lines organization in your writing will consider the width of your cell. If you want to return the writing to one line, then just click the wrap text again

    How to Copy Sheet in Excel - Screenshot of Step 1-4




Method 2 - Shortcut Buttons

  1. Highlight the cell where your writing is

    How to Copy Sheet in Excel - Screenshot of Step 2-1

  2. Place your cursor in front of the writing part that you want to move to a new line

    How to Copy Sheet in Excel - Screenshot of Step 2-2

  3. Press Alt + Enter (Option + Enter on Mac) simultaneously
  4. Done! The lines organization in your writing will consider the width of your cell too

    How to Copy Sheet in Excel - Screenshot of Step 2-4



Exercise


After you understand how to use the two methods, now let’s sharpen your understanding by doing the following exercise!

Download the exercise file of how to enter in excel and do the following instruction. Take a look at the steps for the two methods again if you are confused on how to finish the exercise.

Link of the exercise file:
Download here

Instruction:

Try to make the data form in sheet A to become like the example in sheet B. How is the result? Can you do the instruction?


Additional Note


The second method, shortcut buttons, can also be used during your text writing process. This way of usage might become your preference in making new lines in your data if you think it is simpler.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert