[Affiliate]
Blog Stats
- 3,289,906 hits
-
Join 3,246 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"
- #Excel Add current selection to filter. What it does?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Show number in thousand (k) or in million (M) by using custom format
- Dropdown calendar in Excel
- Contact
- Limitation (or bug?) with Filter by Color
- About
- SUM vs. SUBTOTAL
- The INDIRECT trick of using Structured Reference in Conditional Formatting
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
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
Working with Objects
From a simple textbox, a rectangle to a chart, you may have experience in moving/resizing/aligning or even selecting multiple objects in excel. It could be really time consuming and the result may not be good looking still. :O Have you … Continue reading
Convert unit of measurement from one system to another system
如何在EXCEL轉換量度單位? Have you ever wanted to convert Degree Celsius to Degree Fahrenheit or Meter to Mile in Excel? Yes, I did. What I did was to first Google the formula for such conversion, and then apply the formula manually in … Continue reading
Fill in the blanks – quickly
How to fill up all the blank cells in a Table in less than 1 minute??? The table on the left is a typical output from Pivot Table. The blank cells help to make the table more “reading-friendly”. However they … Continue reading
Do you need TIME?
To convert [hour:minute] into number of hours quickly. If you are working in HR field, you may need to calculate wages for part-time staff whose salary is paid on hourly basis. So you need to convert 8:45 (8 hrs 45 … Continue reading
Quickly highlight the differences in two columns – Go to Special
There are many ways to find out the cells in column B which are different from the cells in column A, e.g. using Conditional Formatting, Using formula in column C. These methods require some knowledge in Formula. Nevertheless, It could … Continue reading
Another useful tips with Go to Special – Visible cells only
This is an extension of the previous post that talks about Go to Special -> Visible cells only Apart from Copy ONLY unhidden rows/columns, another situation we used to run into is probably deleting or modifying hidden cells unintentionally. Sound … Continue reading
How to copy visible cells only?? – GO TO SPECIAL: visible cells only
Have you run into a situation that you wanted to copy a table, like the one below, to a new worksheet. However the Table “expanded” automatically… All the information from the hidden rows and columns reappears. What??? A simple trick … Continue reading
Another use of F4 – Repeat LAST action
Excel tips: F4 to repeat LAST action As mentioned in my previous post, F4 is my favorite keyboard buddy. It helps you quickly shift between relative reference and absolute reference when building formula; it also helps to repeat your last … Continue reading
How to calculate number of days, months, or years from one date to another date – DATEDIF function
如何計算兩個日子之間有多少年／月／日？ Recently, I got enquired about function for calculating number of days from one date to another date. DATEDIF is on the top of my mind. ：） Interestingly this function is not commonly known probably because it won’t show up … Continue reading
Excel Topics Preview
Learning Excel is a series of trial and error. Sometimes it succeeds, most of the time it fails. 🙂 Whenever I learn something new, I will test it again and again in order to make sure I understand the usage. … Continue reading
Posted in General
Leave a comment
How to switch between Absolute and Relative reference? F4
如何快速轉換公式中的絶對參照及相對參照? To kick off my first blog, I would like to introduce my buddy on keyboard to you – F4 To me, it helps 1) Switch between Relative and Absolute reference easily when typing formula 2) Repeat last action Let’s … Continue reading
Excel Journey
“A good teacher teaches; a great teacher inspires.” Long time ago, I had a chance to sit in a class called “Decision Making with Computer” when my excel knowledge was limited to “table drawing” and basic + – * /. … Continue reading
Posted in General
Leave a comment
wmfexcel 