Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
68
Views
Topic starter
In attached file,
Column A and B : No calculation when drag copying
Column C, D and G : Auto calculation for numbers when drag copying
How can change auto calculation for column C, D and G? Please help what to change.
Posted : 04/10/2019 12:14 pm
Hi,
C and D contains text, G has numbers. In text columns, if the number is at the end of the text, it will autofill the numbers when you drag down the cell. In case of column D, it will not work, because it is not ending in a numeric char. For column G, you have to select the last 2 cells and drag down, this way you will be able to fill series in numeric cells.
Posted : 04/10/2019 11:23 pm
