Monthly Archives: September 2015

F5 – It is the key I rarely press

Posted on September 30, 2015 by MF

The working combinations for F5. F5 alone – Open the Go To Dialog box Ctrl+F5 – restore the window size of the selected workbook Shift+F5 – Open Find (and Replace) Alt+F5 – Refresh Pivot Table Ctrl+Alt+F5 – Refresh All Nevertheless, … Continue reading →

Rate this:

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

F4 -It is my buddy!

Posted on September 28, 2015 by MF

Two years ago, I wrote two posts about using F4. How to switch between Absolute and Relative reference? F4 Another use of F4 – Repeat LAST action Honestly, these were the only two ways I know about F4 by that time.  Now … Continue reading →

Rate this:

Posted in Shortcut | Tagged | 2 Comments

F3 – It is about Naming…

Posted on September 25, 2015 by MF

F3 key can be used with the following combinations: Ctrl+Shift+F3 – Create Names from Selection Ctrl+F3 – Open Name Manager F3 alone – Paste Name Shift+F3 – Open Insert Function dialog box As you see, F3 is mainly used for … Continue reading →

Rate this:

Posted in Shortcut | Tagged , | 1 Comment

F2 – It is about inputting and editing… what? Please elaborate!

Posted on September 23, 2015 by MF

Among the F1-F12 keys, I use F2 most often.  Why? Because it helps me edit cell contents quickly.  On the other hand, F2 is extremely  helpful when I try to edit cell reference in chart or revising reference in Name manager. … Continue reading →

Rate this:

Posted in Shortcut | Tagged | 4 Comments

F1 – A must-know key if you are a self-learner!

Posted on September 21, 2015 by MF

This is the first post of the Function Keys series.  Why F1 is the must-know key for self-learner? Because it takes you to Excel Help! 🙂 Literally, the F1 key serves the following in Excel: F1 alone – Open “Need … Continue reading →

Rate this:

Posted in Shortcut | Tagged | Leave a comment

What the Function keys do in Excel?

Posted on September 19, 2015 by MF

F1  F2  F3  F4  F5  F6  F7  F8  F9  F10  F11  F12 F1 to F12 are always sitting on the keyboard quietly.  How often do you use them? In the era of Google, you may find what you need by simply … Continue reading →

Rate this:

Posted in Shortcut | Tagged | Leave a comment

Be careful when using Data Table

Posted on September 12, 2015 by MF

Do not reference a label (be it on row or column) back to the calculation thread used when setting up Data Table. Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 10 Comments

Mouse Tips – Move cell to other sheets

Posted on September 5, 2015 by MF

If you have tried to move a cell from one sheet to another sheet by dragging it to the Sheet tab, you would be frustrated it just keeps you (going) DOWN.  😛

Rate this:

Posted in Excel Tips | Tagged | Leave a comment