im trying to insert a table in a specific range (b10 to bb11)....when I try to add to the table by typing something in b12, the referernces are messed up...eg W12 should be referring to b12, but instead references b13.
yes, i removed the header row and Excel did make a warning about formulas potentially messing up, but I've made a table like this before without references messing up and I can't replicate the result anymore.
yes, i removed the header row and Excel did make a warning about formulas potentially messing up, but I've made a table like this before without references messing up and I can't replicate the result anymore.
Last edited: