- 2,850,793 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- 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
- Perform VLOOKUP with 2 lookup values
- Open an embedded Excel file during a slide show in PowerPoint?
- How to lookup an image in #Excel
- Unstack uneven data across columns with #Excel #PowerQuery
- Show number in thousand (k) or in million (M) by using custom format
- Be cautious when using XLOOKUP
- Same day last year...
My YouTube Channel
- My Tweets
Tag Archives: Fill
Have you ever tried to input “A” and then drag it down with a hope of getting a list of A to Z? If you tried (and without success), you may be wonder how I did it? You may find … Continue reading
If you have followed my blog for a while, you should know that I have created my YouTube channel recently. And a playlist – Excel Magic in One Minute was created in early June this year. So far, I’ve created 25 videos in … Continue reading
Answer to the 5 little Tips (tests) – Part 2/5 Fill a series (of sequential numbers) The task: Fill a big series of sequential number, say from 1 to 24567. Answer: You may find the answer to the question in this post: Fill … Continue reading
First of all, Happy New Year of 2017! Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company. All participants were expected to have basic Excel knowledge. … Continue reading
… Ctrl+D or Ctrl+R is ready to help 🙂 Ctrl+Enter is one of my favorite shortcuts. It helps me to input a value or a formula to a range simultaneously. As usual, Ctrl+Enter won’t let me down. But many times, … Continue reading
In many cases, we may want to create a list of month end dates. This can be done either by formula or Fill. Either way, we should input the first month end date (starting date) manually. Using EOMONTH Syntax: EOMONTH(start_date, months)
Like majority of smartphone users, Excel users (know how to) use only a little portion of functionalities provided by the tool, even though we pay the full price for the tool… Fill Justify (on the editing group of the Home Tab) is … Continue reading
Well, the first thing in your mind maybe using ampersand & or CONCATENATE to combine them. =A1&” “&A2&” “&A3&” “…… =CONCATENATE(A1,” “,A2,” “……) which is more or less time consuming. Two ways to achieve this quickly Using a combination of … Continue reading
Auto Fill is a very handy feature in Excel. I believe many users use it every day. A simple example is to fill a list of sequential numbers, say from 1 to 18. What you need is to input 1 … Continue reading