Tag Archives: Go To

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

Where is the formula referring to???

This is an extension of my post – Teleport in Excel I don’t remember  how many times I want to know where a formula is actually referring to, esp. when I need to spot what’s the formula doing.  If the … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Teleport in Excel

在 Excel 中舜間轉移 Teleportation is still an imagination in reality; it is not in Excel world. When you are working with a large workbook book with many worksheets, or even many workbooks with many worksheets altogether, you are likely to … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 1 Comment