To kick off my first blog, I would like to introduce my buddy on keyboard to you – F4
To me, it helps
1) Switch between Relative and Absolute reference easily when typing formula
2) Repeat last action
Note: You need to do it right after you input the cell/range reference. Otherwise, you have to click in the formula bar and then click on the reference you want to switch before pressing F4.
I will talk about how to use F4 to repeat last action in next post…
If you have other tips in using F4 button, please feel free to share by leaving a comment.