However, with it having wrapped, it is under the cell boundary. The actual text under A1 is beyond the cell boundary. The above screenshot emphasizes the use of Wrap Text. If you click on Merge & Center button again, it removes the effect however, the text gets filled in the left most cell or a cell under which it has actually been entered. On the other hand, Merge & Center merges the data across the multiple cells and then makes a centered alignment for the merged text. Wrap Text shows text in one single cell even if that text goes beyond the cell boundaries. Well, these two are the most commonly used alignment operations in Excel. The fifth and last thing that comes under alignment is Wrap Text and Merge& Center option. Excel has Increase Indent and Decrease Indent option that helps you either increase or decrease the indent in your current text. However, you don’t need to keep it in your mind. Most of us fail to recognize when to add or decrease an indentation. This feature is rarely used though sometimes it is really helpful when you want to do something different with the headings of your reports.įorth thing that gets covered under the Alignment section is the indentation.
This option has different text rotation options available, allowing you to rotate the text with angles (clockwise)and vertically (up and Down). The third part that gets covered under the Alignment group is the Text Rotation option. They are placed in the second tier of the options under the Alignment group. These are placed at the top most tier under the Alignment group.Įxactly below to these three, there are three more alignment options. The first three are Top Align, Middle Align, and Bottom Align. We have several alignment options available under this Group. This part also plays an important role in text formatting. Now we will move towards the second group called Alignment. This is how we can format the text using the Font Group. See the screenshot below for your reference: You can simply click on the change color dropdown and see different colors to add for the current text value. This option is placed under the Font section in your excel ribbon. We also have an option to change the text color for a given text. See the screenshot below for better visualization of these two options. It adds a double underline to the current cell containing text. There is one more option for the underlined section, and it is Double Underline. You can underline the text by using the Underline button that is placed besides the Italic button the keyboard shortcut to achieve this result is Ctrl + U. This can be achieved through a keyboard shortcut Ctrl + I. Select the cell and click on the Italic button that converts the text into Italic font. You can also achieve this by hitting Ctrl + B keys. Select the cell containing text and click on the bold button. This covers the Bold, Italic, underlined text as well as coloring the text and/or cell containing the same. The next part comes when we have to change the text appearance. You can also increase or decrease the font size using the Increase Font Size and Decrease Font Size buttons, which are placed right beside the Font Size dropdown.
Please see the screenshot below for your reference. Click on the dropdown, and you can see different font sizes starting from as low as 8. Select the cell containing text (A1 in our example) and navigate towards the Font Size dropdown placed besides the Font option. Now, we will try to change the font size. within Font, you can have all the options associated with text fonts. Each group has a variety of options using which we can format the text values and has its own relevance. Basically, all text formatting can be divided into two major groups, which are Font and Alignment. This article will cover these text formatting tools in Excel along with examples for better understanding. This includes changing Font, Font Size, Font Color, Font Attribute (Such as making text, Bold, Italic, Underlined, etc.), text alignment, background color change, etc. Text formatting in Excel works in the same way as it does in other Microsoft tools such as Word and PowerPoint.
0 kommentar(er)
