Excel Tricks with Tejraj

Many times, while working in excel, we may face a situation where, we have a data with specific formatting style and we want to copy same formatting style in another location. We can do it manually but it will be very critical while working on a large data also it is time consuming. To do this task within a seconds, there is one command available in excel: “Format Painter”. We can find this command in Home Tab under Clipboard Group. So let’s have a look on how we can use this command effectively to save our time and efforts. Here we will take an example of Marks scored by students in Maths and Science. In Table 1, we have listed marks scored by five students in Maths. We have applied some formatting to this table as below: 1. We made text in the first row of this table to Bold. 2. We have applied border to entire table. 3. We have changed background color of all the cells from table to Light Green. Now we have another data in Table 2, in which we have listed marks scor...

There might be question in your mind: “What is the difference between Paste and Paste Special?” If you really had this question then you are reading perfect blog. This blog will help you to answer your question. Also we will see how we can use each and every option from Paste Special to reduce our time and efforts.  We can say that Paste Special is subset of Paste. Both the Paste and Paste Special does the same thing (to paste the data) but “Paste Special” paste the data in a special way. So let’s see what these special options available in it are. YouTube Video Where we can find “Paste Special”? There are two ways by which we can reach up to Paste Special options. But for this we have to copy the data first which we want to paste. After we copy the data we can follow any of the below steps: 1. Click on the small downward arrow below “Paste” command in Clipboard group under Home Tab, we will see one option called as “Paste Special”. 2. Right click on any cell ...