Excel Tricks with Tejraj

In our previous post " Fill Series in Excel " we have seen all the details about " Fill Series " options. Let us see the examples of each option in this blog post. Fill Series: Linear Trend In this section we will see how we can fill series with linear trend using fill series. Suppose, we want to fill series 1, 2, 3…. upto 20 in a column.  1. Enter value 1 in any cell and select this cell. Go to “Home Tab” then select “Editing Group” then select “Fill Command” then select “Series option” and Input the values as mentioned below in Series Dialog Box:      a. Series in: Column      b. Type: Linear      c. Step Value: 1      d. Stop Value: 20 2. Once you click on “OK” button then you will see a desired series on your screen. Fill Series: Growth Trend In this section we will see how we can fill series with Growth Trend using fill series. Suppose, we want to fill series for which the series pattern will be like: 2, 4, 8…. upto 2...

In our previous post “ Fill Up, Down, Right & Left in Excel ”, we have seen fill up, fill down, fill right and fill left commands in excel. Now, in this post we will see “Fill Series” command in excel. The basic difference between “ fill up, fill down, fill right and fill left commands ” and “Fill Series” command in excel is that: “fill up, fill down, fill right and fill left commands” fills the data as it is. It is similar to copy the data from one cell to selected cells. But “Fill Series” command help us to fill the data in series. It means it helps us to fill the data in certain pattern. Also we can customize the series in which we want to fill the data with the help of options available in this command. Select “Home Tab” then select “Editing Group” then select “Fill Command” (Image is given below for your reference) Once we click on “Fill” command, various fill options will display on our screen. Select “Series” option from it. Once we click on “Series” option then we will ge...