Blog Stats
- 2,324,824 hits
- 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?
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Perform VLOOKUP with 2 lookup values
- Filter a list of items from a long long list
- Open an embedded Excel file during a slide show in PowerPoint?
- Insert a text string into a specific position of another text string in #Excel
- Dropdown calendar in Excel
- Be cautious when using XLOOKUP
My YouTube Channel
My Facebook page
- My Tweets
Monthly Archives: September 2016
Insert “tick in a box” in Excel
Recently, I’ve been collecting Excel files from colleagues regarding implementation status of some activities in the region. Part of the template looks like the screenshot below: Quite simple and straight forward, right? I expected I would get something like the following in … Continue reading
Three years of Excel Blogging – A quick review
Note: This is not an Excel post… I totally forgot that today is the 3rd Anniversary of my Excel blog. Time really flies. Thanks WordPress for sending this 3rd Anniversary notification to me. What’s a pleasant surprise! 🙂 Did you … Continue reading
Posted in General
4 Comments
Move cells with data to the top
Did you spend too much time to move cells so that there are no blank cells in each column? Again, a picture tells thousand words. Here’s the task… Would you do it this way? Or this way? What did I do … Continue reading