Excel Tricks with Tejraj

In many situations we need to apply borders to data which we have entered in our excel sheets. Mainly when we are preparing dashboards or preparing any templates, applying right border style will make your work very attractive. So let’s see how we can apply different border style effectively in excel.  YouTube Video: Borders can be found in the Font group under Home Tab.   There is one downward pointing arrow available beside Border icon. If we click on this arrow, we can see multiple border styles which we can use effectively to make our work attractive. For first 09 options of border styles as given below (Point 1 to 9), we will apply these border styles one by one to cell B2 (B2 means cell with column B and row 2). This cell without any border will looks like below: 1. Bottom Border :  This will help to apply border at the bottom side of the selected cell. Click on the downward arrow available beside border icon. Now select on the Bottom Border option

Bold, Italic and Underline… These three commands are very basic but very important and frequently used in excel. These commands can be found under Font Group. YouTube Video: Let us have detailed description about these commands..!                                              Bold : If we want to change our text into Bold format, then we can use this command. Keyboard shortcut to use this command is Ctrl+B. In below image we have inserted a sample text in cell A1. If we click on the Bold icon from font group or use keyboard shortcut Ctrl+B, then the text from cell A1 will convert into Bold as shown in below image. Italic : If we want to convert our text into Italic format, then we can use this command. Keyboard shortcut to use this command is Ctrl+I. In below image we have inserted a sample text in cell A1. If we click on the Italic icon from font group or use keyboard shortcut Ctrl+I, then the text from cell A1 will convert into Italic as shown in