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 talk about 1) first…


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.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Formula, Shortcut and tagged . Bookmark the permalink.

1 Response to How to switch between Absolute and Relative reference? F4

  1. Pingback: IF AND statment....

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.