User Posts: Alif Bin Hussain
If you need to calculate the export price of your products, using Excel can be very handy. If you have to do it on a regular basis, you might need your own ...
Sometimes we change the names of cells and ranges as per our need for various purposes in Excel. While working with a large dataset with lots of named ranges, ...
Excel can be a very helpful tool to keep track of your loans and mortgage. You can calculate offset mortgages in Excel to reduce the total interest while ...
The number of miles a vehicle can travel using a certain amount of gas or fuel is known as gas mileage. A vehicle user might want to keep track of the vehicle ...
While working with numbers, it is often required to sort data from largest to smallest. Although it is a very easy task, sometimes it might not work correctly ...
The ISNUMBER function is very useful to find out if a cell value is a number. This function can also be combined with IF and Then statements in Excel for ...
Interpolation is a process of determining the value of an unknown point that lies between two known data points. While calculating linear interpolation is an ...
The Format Painter tool is very useful for copying the format of cells to multiple rows. Using the Format Painter, one can apply formatting to adjacent as well ...
While working with data in Excel, sometimes it is convenient to insert pie charts or histograms to analyze data easily. If you want to analyze the test results ...
When working with a large number of data in Excel, it may be difficult to locate a value or a piece of data. Using VBA code this difficulty can be solved which ...
Excel is a very useful software to represent data using tables and charts. It is a handy tool to arrange data and charts in ascending or descending order to ...
When we copy something from different sources and paste it into an Excel cell, the cell format changes automatically. To keep this from happening, we can use a ...
An individual might need to sum up only the values that satisfy certain criteria from a large dataset. The DSUM function can be very useful if we want to add ...
Excel is a very useful tool for plotting different kinds of charts. Excel offers various options to format the plotted charts to make it look more attractive. ...
While working in Excel, we often use the AND function. Sometimes we also use the OR function. There are times when we might need to use both the AND and OR ...
Hello Theo,
Follow these steps to adjust ranges to make a longer list without any error.
1. First, to make the task list longer, select cells H13 through J13. Then drag the fill handle down to add new task.





2. In this example, we added five new tasks. Therefore, the new ranges for column H, I and J are H6:H18, I6:I18 and J6:J18 respectively.
3. Then select cell D6 and change the ranges of H,I and J cells in the formula bar and press Enter. After that, Autofill formula up to cell D9.
4. Similarly, change the formula ranges for other cells as well.
5. Finally, you can see in the following figure that the formula is working properly.
I hope this solves your problem. Please let us know if you face any other issues.