Basic Excel problems

Question

I am facing problems in excel, support team said to be in touch with the community. When I am entering formula, it's auto populating into cells below and not able to stop that from even after unchecking relevant boxes in the options menu.

Answer 1

Hi @Sanju Muraleedharan , Welcome in Community

This is happening because your data is formatted as an official "Excel Table," which triggers a feature called Calculated Columns.

Follow these step do disable it:

1.Open Excel Options:

Click File in the top ribbon, then select Options at the very bottom left.

2.Navigate to Proofing:

Select Proofing from the left-hand menu.

3.Open AutoCorrect Options:

Click the button labeled AutoCorrect Options... on the right side.

4.Disable Calculated Columns:

Go to the AutoFormat As You Type tab. Uncheck the box that says Fill formulas in tables to create calculated columns.

Click OK twice and let me know how it goes

Elvis

Answer 2

IF & AND combination formula not working

Answer 3

I want to stop formulas from flash filling automatically in cells below

Answer 4

If the formula is filling cells below automatically, the formula is likely returning more than one value. In Excel, that creates a spilled array, which fills the cells underneath and shows a border around the filled range. To stop that behavior, change the formula so it returns only one value instead of an array.

If the issue is with formulas in an Excel table expanding into new rows, a common cause is that the column does not contain one consistent formula. If one cell in that column contains a fixed value instead of the same formula pattern, Excel may stop treating it as a calculated column.

Try this:

1. Check whether the formula is meant to return a single result or multiple results.
   • If multiple cells are being filled with a border, the formula is behaving like an array formula.
   • Rewrite it so it returns one value only.
2. If this is happening in a table column, verify that the entire column uses one consistent formula.
   • If one cell contains a typed number or a different formula, clear that column and re-enter the formula in the first data cell.
   • Excel should then copy the formula down the column and continue doing so for new rows.
3. If formulas are not updating correctly after being filled, check calculation mode.
   • Go to the Formulas tab.
   • In Calculation Options, make sure Automatic is selected.
4. If formulas are producing unexpected results when filled, review the cell references.
   • Relative references change as the formula is filled.
   • Absolute references use $, such as $A$1, to keep a reference fixed.
5. If needed, use Excel’s formula error tools.
   • Go to Formulas > Formula Auditing > Error Checking.
   • For ignored errors, go to File > Options > Formulas and reset ignored errors.

---

• Formula applies to unwanted cells and they get wrapped in a blue border - Microsoft Q&A
• Excel formula not expanding in tables - Microsoft Q&A
• Detect formula errors in Excel
• Copy a formula by dragging the fill handle in Excel for Mac
• Excel simple formulas not updating - Microsoft Q&A