A while ago, somewhere on the interwebs, I came across a macro. If I find the source I will link back to it. But this thing saves me on a daily basis.
All you do, is press ALT+F11 and paste the following code into "This workbook"
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
It will look like this:
And this will auto-adjust the cells as you type!