[Affiliate]
Blog Stats
- 3,266,374 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Rename column names in a dynamic way with #Excel #PowerQuery
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Highlight weekends and holidays using Conditional Formatting in #Excel
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
- #Excel Add current selection to filter. What it does?
- Insert blank columns to table in #PowerBI Desktop
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- When unhide row doesn't work...
My YouTube Channel
My Facebook page
- My Tweets
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
Posted in Shortcut
Tagged FIND, Find and Replace, Function Keys, Go To, Go to special
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
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
wmfexcel 