Tag Archives: F4

Another use of F4 – Repeat LAST action

Excel tips: F4 to repeat LAST action As mentioned in my previous post, F4 is my favorite keyboard buddy.  It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last … Continue reading

Rate this:

Posted in Excel Tips, Shortcut | Tagged | Leave a comment

How to switch between Absolute and Relative reference? F4

如何快速轉換公式中的絶對參照及相對參照? 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 Let’s … Continue reading

Rate this:

Posted in Excel Tips, Formula, Shortcut | Tagged | 1 Comment