[Affiliate]
Blog Stats
- 3,288,198 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- Sequential number for visible rows only
- Show number in thousand (k) or in million (M) by using custom format
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Dropdown calendar in Excel
- A trick to SUM visible columns only (without VBA)
- Copy data from strictly-protected sheet
- #Excel Add current selection to filter. What it does?
- Advanced vlookup - wildcard characters "?" and "*"
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
SUM ignoring errors in the range
Different ways in getting sum of a range with “Error” Thanks to the comments made by a friend, I would like to share a few workarounds to ignore errors with SUM. 1) Use a helper column This would be an … Continue reading
Dynamic Dependent Dropdown by Data Validation
So many D. 😀 This is a continuation of the previous post: Not all teachers are eligible to all classes. e.g. only Iris and David are eligible to deliver Class F, would it be feasible to have only Iris and … Continue reading
Dynamic Dropdown – Least hours assigned always on the top
How to use Data Validation to show a dynamic drop-down list to facilitate job allocation problem? I learned about using Data Validation long time ago. It’s quite handy and useful when you want to restrict user to enter items only … Continue reading
Arrange multiple Windows of the same Workbook!
How to view different worksheets of the same workbook side by side? It’s quite normal to have two workbooks opened; and more than common to view the two workbooks side by side:
Input special characters in Excel by pressing Alt + Numpad
Perhaps you know that you can input some special characters/symbols by pressing Alt + Numpad together. If you google “ALT Numpad”, you will probably find many extensive lists of special characters input in this way. Well, what to do with … Continue reading
Why do you turn off Auto Filter and then turn it on again??
I have seen many people turning OFF and then ON Auto Filter in order just to SHOW ALL values (in Excel 2003’s terms) or CLEAR all filters (in Excel 2007 or above’s terms). Frankly, I think many people do this … Continue reading
Time Conversion – How to convert 24hr input as 4-digit number into TIME in Excel?
How to convert something like 1200 into 12:00? For easy sake of input, we often input 24-hr time as four digit number like 930 for 9:30, 1815 for 18:15 etc. However, if time is input in this way in Excel, … Continue reading
How to lookup only partially-matched value?? – Crazy lookup!!!
This is a real workplace problem. Look at the two tables below, the task was to map the Shop ID from Table 1 (left) to Table 2 (right). In both tables there is a common key “Shop Name”. Sound easy? … Continue reading
Where did I save this file???
One day, a colleague suddenly asked me: “do you know where I saved this file?” by showing me her monitor with the file opened… Well, the first thing came to my mind was…… well……, input this formula in any blank … Continue reading
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
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs. Finished jobs were identified by Strikethrough … Continue reading
Calculating % Change is so easy… to make a mistake!
How to calculate percentage change with negative number? I believe calculating percentage change should have a very top ranking on the most frequently used calculations in spreadsheet. Agree? For me, I often simply do the calculation with a simple formula: … Continue reading
Quickly set consistent column width throughout the whole table
I think many people know how to AutoFit column width in Excel. In case you don’t, you can simply move your cursor in between the column headers, when you see a cross with left-right arrow, double-click. Then the column width … Continue reading
Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
As mentioned in my previous post, I am going to talk about another built-in function that is not commonly used (in my limited community)… 😛 COPY, PASTE linked picture (aka “Camera”, which is actually available in Excel 2003; not sure … Continue reading
Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V
“Copy and Paste Value” is probably one of the most popular actions taken by many people every day. A probably fastest way to do so is definitely worth sharing. I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts) by MYNDA TREACY … Continue reading
Posted in Excel Tips, Shortcut
Tagged Copy and Paste, CTRL C, CTRL V, Keyboard Shortcut, Paste Value
6 Comments
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
Dropdown calendar in Excel
UPDATE on 7/24/20202: Don’t miss the video at the end of this post. Did you ever ask why Excel does not provide Dropdown Calendar for date selection? Like the one shown below: I did. I asked that because I didn’t … Continue reading
wmfexcel 
How to insert picture / photo into comment?
Happy Valentine’s Day!! Tomorrow is a very special Valentine’s Day as both Chinese and Western Valentine’s Day fall onto the same day. It happens only once in every 19 years. Let’s send your special feeling to a special person subtly … Continue reading →
Rate this: