[Affiliate]
Blog Stats
- 3,191,126 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Open an embedded Excel file during a slide show in PowerPoint?
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Lovely stickers in #Excel 365
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Case-insensitive SUBSTITUTE???...
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