We generally see a “Warning Dialogue Box” like:
This is seen when we try to put a formula, value or formatting to a big range (many cells) at a time in Excel worksheet.
So the good part is, we can modify the number of cells for which the dialogue box gets popped-up. And how do we do this:
Simply, Open Excel File -> Goto Excel Options-> Goto Advanced Tab -> In Editing Options, we can find one option like highlighted below:
We can set any number in the box given there (in Thousands).
Now, if we perform any calculation on the a bigger range than specified, the Warning will be popped-up.