Question: I have a quad-monitor setup (two stacked rows of two monitors) and a PC running Windows 10.

Problem
=======

The problem is that the intersection point of the monitors never lines up perfectly. The four screens are identical and I fiddled with the display arrangement *extensively*, but regardless of how much I play with it, there always seems to be a gap (as shown in the second picture below).

The thick black line shows the separation between the top left and bottom left screens. What it doesn't show is that the bottom left and right screens are also slightly offset from their top counterparts. The right side of the bottom left screen is at the light grey outline of the dark grey window, while the top left screen's right side is shown by the faint change in blue tones.

The second image of the intersection highlights the bad separation in red (emphasis of intersection problem in dark red) and the good display junctions in green. The top screens both need to move left and the top left screen needs to move down. Easy in theory, impossible in practice?

[![Picture of display settings](https://i.stack.imgur.com/NumB7.png)](https://i.stack.imgur.com/NumB7.png)
[![Intersection of multi-display](https://i.stack.imgur.com/JwMZ0.png)](https://i.stack.imgur.com/JwMZ0.png)
[![Intersection of multi-display outlined](https://i.stack.imgur.com/0QsAC.png)](https://i.stack.imgur.com/0QsAC.png)

---

Question
========

How can I remove this gap?

Answer: 
1) Select the cell containing the formula

2) Highlight the formula's text in the Formula bar

[![enter image description here](https://i.stack.imgur.com/iAUVn.png)](https://i.stack.imgur.com/iAUVn.png)

3) Copy (`CTRL``C`)

4) Press `ESC`

5) Select the cell where you want to paste the formula

6) Paste (`CTRL``V`)
Another way is to write your formulas with direct references. Use $A$1 rather than A1. Or $A1 if you want only the number to increment but the column to stay the same, or vice versa (A$1).