Forum Discussion

Dirk1's avatar
Dirk1
Occasional Reader
Nov 13, 2025

#Spill. How can I get rit of it

undefined

2 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor

    something in and or about that formula wants to output a range of values and that range of rows/columns it is trying to spill those results into include 1 or more cells that already have a value or formula.  So either delete or move the existing data/formula(s) out of that 'spill range' or change the formula so it is not outputing as large or any spill values.  If you were not expecting a range of values output then you probably made a mistake in the formula.  Here are some simple spill examples:

    =A1:A10   <= this will copy the values from A1:A10 and show them in the current cell and spill into the the 9 cells below it 

    =XLOOKUP( A1:A10, B1:B10000, C1:C10000 )   <= this will use the values in A1:A10 and for each respective value is will look in B1:B10000 for that value and return the corresponding value in C1:C10000.  This will spill the same as above with this cell plus the 9 cells below it.

    =SEQUENCE( 10,10 )   <= this formula will create a sequence of number 10 rows and 10 columns so it will spill 10 down and 10 to the right and display the number 1 - 100

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    What a nice problem description !!!
    Check https://support.microsoft.com/en-us/office/how-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023

Resources