At times we may need to enter long data in Microsoft Excel in a single cell. At that moment we may need need to expand the cell width or length which makes the sheet look irregular. This happens when the settings is not set to auto fit for cells or rows and columns. This is one of the best things
It can be done in the following way:
It can be done in the following way:
- Select the cells you want to wrap.
- Click on Home Tab and in the ribbon click on Wrap text.
- It will wrap the text by increasing the height of the cell row.
 |
| After Wrapping |
Method 2:
- Select the cells you want to wrap and right click on the text.
- Choose format cells
- Click on Alignment Tab
- Choose Wrap Text
- This will wrap the text in cells.
 |
| Word wrap by Right Clicking |
2 comments:
Nice Blog Post !
In this is just a very simple short WordPress tutorial videos tutorial on how to wrap text around a video I've also got a video on this blog post how to read wrap text around an image or a picture very very simple to to wrap text around and imaging WordPress of I've made up a video not put that on this blog post as well that the blog post is actually about how to wrap text around a video so if you don't want to just put the video up the top here you want to put it to the size to the left of the right it's very good very easy but what you need to do is you need to add a bit of code so I've written that code and I've put it in pink here on my site on this on this actual blog post only
To know more click here
Post a Comment