Blog Stats
- 1,984,204 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- When unhide row doesn't work...
- 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 sort bar chart in descending order?
- Insert a text string into a specific position of another text string in #Excel
- Perform VLOOKUP with 2 lookup values
- Same day last year...
- How to lookup an image in #Excel
- Dropdown calendar in Excel
- Filter a list of items from a long long list
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Ctrl Enter
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
