I don't know if this is a trivial problem but it is driving me nuts. I have two columns like this:
| A |B| | |5| | |3| |100|2| | |5| | |2| | |3|
In column A all cells are merged and I use the values of column B to calculate a percentage. I have to select all cells in column B. As soon as I enter "=SUM(" and start clicking on the cells I need I have an overlap in column A which covers my values in column B so I can't see the cells in column B. Is there a way to prevent this?