Excel Tricks with Tejraj

In this blog post we will see how we can adjust Row Height and Column Width of cells in excel sheet. The options to adjust Row Height and Column Width in excel are available in Home Tab under cells group. Once we go to Cells group, click on “Format” command and then under Cell Size we can find all the options to adjust Row Height and Column Width. Let’s learn more about this with real time example. We have a dummy data of marks obtained by five students with us. But the data is not well organized. The Row Height and Column Width of cells which contain this dummy data is not equal which giving an ugly look to our data. So let’s adjust Row Height and Column Width for these cells so that our data will look more attractive. Row Height: Select all the cells for which we want to adjust Row Height. Select "Row Height" option under “Format” command as shown in below image. Row Height dialog box will appear on screen. Here we can enter the value to adjust Row Height. We have provided ...

To explain “Date Filter“ in detail, we have a dummy data of some electronics products sold in 04 regions East, West, South and North from 1st Jan 2019 to 31st Dec 2021. Date filter can only be applied for the column which contains Date values. In our case we can apply Date filter for the Date column. Click on the drop down button which is available on header cell “Date” and click on “Date Filters” option as highlighted in below image. We can filter data available in this Date column based on below criteria’s: So let us now see each of the criteria in detail.  Please make a note that we will consider today’s date as “13th September 2020” throughout this post. So all the output results shown in this blog post will depend on this date. Equals:  This option will help us to filter the dates exactly equal to our input date. For example if we want to filter the data for date 1-Jan-20 then we will provide our “equals” criteria as shown in below image. This will provide us the output a...