Excel Tricks with Tejraj

Many times we use colors in our excel files to make our work attractive. We can apply colors to the texts as well as to the cells.  If we want to change the color of text available in cells then we use the various color options available from “font color” command. Similarly, if we want to change the color of cells itself then we use the various color options available in “fill color” command. But have you ever wondered that what are names of different colors available which we can apply to texts and cells?? YouTube Video In this post we will see details about this.  The color options which are available in “font color” and “fill color” commands are as below: Fill Color: Font Color: If we compare above two images, we can see these color options are categorized into two categories. 1. Theme Colors 2. Standard Colors Theme Colors: There are total 60 different colors available in (06 rows x 10 columns) in Theme Colors category  (These colors w...

Sometimes we receive a data in Excel file which contains long text. To view this long text written in a single cell we have to adjust the column width as per the text length. But by doing this we may result in a very poor visibility of entire data.  So how we can see a data which contains long text in a single cell???  YouTube Video Well, excel have given a fantastic solution with "Wrap Text" command. With the help of this command we can make our content visible in a single cell. This command splits the long text into multiple lines within a single cell.  We can find this command in the Home Tab under Alignment group. For better understanding this is highlighted in blue color in below image. Let’s take an example to get clear idea of this command. We have taken marks obtained by 05 students in English, Maths and Science subjects. But if we observe carefully in below image, the data in yellow highlighted cells is not visible completely. The reason behind ...