In this article, I am going to share with you how you can use the Wrap text function of Microsoft Excel. So, follow below some simple and very easy steps to know how to use this function.
The Wrap text function helps to merge or display your long text into a single cell by adjusting this in a single cell. This function helps your data to look better, and attractive, by adjusting rows and columns makes your data look attractive and you can also design your data with different colors.
Wrap Text in MS Excel
Step 1: Open your saved spreadsheet or create a dummy data spreadsheet to perform this function or test this function.
Step 2: Type your long text in a single cell as I have written in the A1 cell and B1 is empty.
Step 3: Now, go to the Home tab, and in the group of Alignment click on the Wrap text. Shortcut for this function is (Alt + H + W).
Step 4: Now, see the result.
Step 5: Now, double-click the border of Row A and B to adjust this automatically. (No shortcut key for this, just double-tap to adjust).
- How to Calculate Mean in Excel
- How to deduce the Coefficient of variation using Excel
- How to Transpose in Excel
- Why is my excel file so large?
- Excel Formula to Remove Characters
Now Alling you’re as per your need by clicking above.