I have been writing about Microsoft Office for many years, and currently I am working on updating the articles on my website. If you want to change the reference type of a cell in an Excel formula creation, you can use the F4 key in Window…