How to stop function in single cell from automatically filling entire column?

Question

When I enter a function into a single cell, it fills for the entire column. Is there a setting that is enabling this? Can it be disabled? I am neither selecting multiple cells, click and dragging, or double clicking the lower right. I am only entering the function into the function bar and pressing enter.

I do not want the entire column to fill with this function. This also causes the program to run really slow and frequently causes it to crash or say that too many resources are being used, even if there is nothing else on.

How do I stop this from happening?

Answer 1

Hi,

Have you accidentally converted the entire column/entire worksheet into a Table?  A formula entered in a certain cell of a Table will automatically get copied to all cells of that column.

Select any cell of the formula column and see if there is a yellow "Table Tools" button appearing in the title bar of your Excel file.

Answer 2

Hello:

Is this happening in every workbook even a new workbook or a specific one?

Try to open Excel in SAFE MODE, In Run enter this..."excel /safe" (no quotes), if the issue is gone through safe mode, disable any Add-Ins or delete the Macro that causing the issue.

By the way: may we know which FUNCTION you are using?

Thanks,

Jaeson