Excel Tricks with Tejraj

There are many occasions when we want to clear unwanted things while working in excel. In this blog post we will learn about “Clear” command in excel which will help us to clear the unwanted things in excel sheet. We can find this command in “Home” tab under “Editing” group as shown in below image. “Clear” command is divided in 06 categories: 1. Clear Formats 2. Clear Comments 3. Clear Hyperlink 4. Remover Hyperlink 5. Clear Content 6. Clear All Let’s learn about this in detail… We have created dummy data to explain all these categories as shown in below image. Let us understand this dummy data first. This data is well formatted with header row highlighted with dark blue color with bold font having white font color. All the other rows are having light blue color with blank font color. Also we have applied “All Borders” to our entire data. (To learn more about types of borders Click Here). We have inserted two comments in our data in “Experience in Years” column for employees “CCC and “...

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...