[Affiliate]
Blog Stats
- 3,266,408 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"
- How to replace value with a value from another column in Power Query
- Show number in thousand (k) or in million (M) by using custom format
- How to sort bar chart in descending order?
- #Excel Add current selection to filter. What it does?
- Perform VLOOKUP with 2 lookup values
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- SUM vs. SUBTOTAL
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Ctrl Enter
Replace blanks with zero in #Excel
Following the techniques used in the previous post , we can perform many Excel magics for different scenarios. On top of my mind is to replace blank cells with zero. The first task is to select all blank cells in … Continue reading
Posted in Excel Tips
Tagged Ctrl Enter, Find and Replace, Go to special, Keyboard Shortcut
Leave a comment
Unstack data across columns with #Excel Pivot Table
Another commonly seen problem in daily work. Many hours are spent on reshaping data, we all know that. Nevertheless, if you are good in Excel, doing this task is not difficult at all. Indeed, there are many ways to solve … Continue reading
Ctrl+Enter won’t let you down!
As you may be aware of, Ctrl+Enter enables you to input the same thing (be it text, value or formula) in multiple cells simultaneously. See screenshot below for example: It is quite handy and I use this trick a lot in … Continue reading
wmfexcel 