Excel Tricks with Tejraj

Whenever we want to adjust our text in a narrow cell, we can use Orientation command in excel. With the help of this command, we can rotate the text clockwise, counterclockwise, upward downward etc.  YouTube Video We can found this command in Alignment group under Home tab. If click on the orientation command icon. You will see a dialogue box with below options appear on your screen. There are 05 options we can see in the above dialogue box. 1. Angle Counterclockwise 2. Angle Clockwise 3. Vertical Text 4. Rotate Text Up 5. Rotate Text Down So let's see how to use this command.  First select the text where we want to apply the orientation. As an example, we have inserted a text "Excel Tricks with Tejraj" in a cell and we will apply all these orientation styles to these text: 1. Angle Counterclockwise: This option will help us to rotate the text counterclockwise within a cell. Select the text to which we want to apply Orientation st...

In excel, we can adjust the text written in a cell at the top, middle, bottom, left, center & right. Using correct alignment style will help you to make your work attractive. So let’s see what are these alignments in excel and how to use them.  YouTube Video These commands are available in Alignment group under Home Tab. Below image will give you clear idea where we can find these commands. There are six alignment commands available in Excel:  1. Top Align 2. Middle Align 3. Bottom Align 4. Left Align 5. Center Align 6. Right Align We can divide these 06 alignment commands into 02 groups based on the movement of text after selecting respective alignment command: 1. Vertical Movement of Text: Top Align, Middle Align, Bottom Align 2. Horizontal Movement of Text: Left Align, Center Align, Right Align Let’s see each of above one by one. As an example, we have inserted a text “Excel Tricks with Tejraj” in a ...

To make the data in our excel sheet more attractive, it’s always good practice to use the font commands effectively. To do so, we can use various  command   from Font group. These  command   are: 1. Font Styles 2. Font Size 3. Increase Font Size 4. Decrease Font Size 5. Font Color 6. Fill Color YouTube Video We will now see these  command  one by one:  Font Styles :   We can change the font style of our text in excel with the help of this command . This  command  is available in Font group. If we click on the downward pointing arrow which we can see beside the font styles, then we can see multiple font styles available in excel. For example, if we want to change the font style of our text in excel to “Agency FB” then select the desired text first. Now click on the downward pointing arrow which we can see beside the font styles and select the option “Agency FB”. The selected text will be reflected into “Agency F...