Jul 21 2021 07:00 AM
I am trying to link my cell to another tab and keep getting the error #SPILL!. I`m unsure why.
Has it anything to do with the merged cells.
I`ve attached the spreadsheet.
I`m trying to link cell B3 on 'Declining Test' tab to cell D6 on 'Qualification Details' tab.
Jul 21 2021 07:05 AM
@jamesco655 Yes! Get rid of the merged cells. They cause only trouble.
Jul 21 2021 07:09 AM
Jul 21 2021 07:28 AM
Solution@jamesco655 I dare to say that there is almost NEVER a need to merge cells. The cosmetics you describe can be achieved by filling the cell with a white background and then format the borders how you want it to look like. See attached, where I did just that in D6:F14
Jul 21 2021 07:28 AM
Solution@jamesco655 I dare to say that there is almost NEVER a need to merge cells. The cosmetics you describe can be achieved by filling the cell with a white background and then format the borders how you want it to look like. See attached, where I did just that in D6:F14