Monthly Archives: September 2015

F5 – It is the key I rarely press

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!

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…

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 , | Leave a comment

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

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!

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?

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

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 , | 8 Comments

Mouse Tips – Move cell to other sheets

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