- 3,070,571 hits
Join 3,281 other subscribers
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- How to sort bar chart in descending order?
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Open an embedded Excel file during a slide show in PowerPoint?
- Send a cell content to Google search
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Basic
Do Not input “-” for zero. Use proper formatting in #Excel
Do you input a hyphen to represent zero? If you do, please stop doing so in the future. The proper way of displaying “-” for zero is to apply relevant cell format to it. E.g. Using Accounting format with no … Continue reading
Posted in Excel Basic, Excel Tips, Format Tagged Custom Format, Format, Power Query, Replace Values Leave a comment
Number Stored as Text…
It is something basic and commonly seen. Nonetheless, it is really important to understand the different behaviors between a number, and a number stored as text, especially if you want to move forward to write effective formula. This post is intended … Continue reading
Posted in Excel Basic, Formula Tagged Array formula, ISTEXT, Text to Columns 6 Comments
Convert .xls to .xlsx in a few clicks
Let’s bring the Excel file from stone age back to modern world. A few years ago, my company switched from Office 2003 to Office 2007. I was one of the very few who felt excited about the change. On the … Continue reading
Posted in Excel Basic, Excel Tips Leave a comment
Sort by row (i.e. from left to right)
Sorting is easy, when the orientation of data is vertical. Although we are expecting data in a vertical layout, it is not uncommon that we still encounter data in a horizontal layout in real world. Don’t you? With data in a row, … Continue reading
Posted in Excel Basic, Excel Tips Tagged Sort 2 Comments
Hidden Rows vs. Filtered Rows
One day, a friend asked me: “If she deletes contents from a filtered range, would she also delete the hidden content?” I answered: “Try and observe!” 😛 I know that is not the answer she expected. Nevertheless, I believe that … Continue reading
Posted in Excel Basic Tagged Auto Filter, Visible cells only 1 Comment
Show number in thousand (k) or in million (M) by using custom format
The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is optional, depend on whether you want to show it in the header or in the figure itself. The trick is … Continue reading
Posted in Excel Basic, Excel Tips Tagged Format 12 Comments
Advantages of having date input correctly in Excel
In previous posts, what do we need to know about inputting date in Excel was discussed. Suggested solutions for fixing trouble dates were also given. But WHY having date input correctly in Excel is so important? Why should we care? Answer: It’s … Continue reading
Posted in Excel Basic, Excel Tips Tagged Date 1 Comment
What we need to know about inputting Date in Excel?
When you type “1/5/2015” into Excel, do you know whether it is “1st of May, 2015” or “5th of January, 2015”? The answer: It depends! Depends on what?
Posted in Excel Basic Tagged Date 1 Comment
Are you sure you have input a date correctly in Excel?
Although they sound like basic questions, I am quite surprised that many colleagues are not aware of the different ways to input date in Excel “correctly”. I would like to understand the situation of other Excel users by putting a poll … Continue reading
Posted in Excel Basic Tagged Date Leave a comment
Clear or Delete? A hassle-free way to clear everything in a cell
Do you have a habit of right-click a cell and Delete it rather than pressing the “Delete” button on keyboard? If you do have this habit, I guess you possibly are frustrated by the following experience before:
Posted in Excel Basic, Excel Tips Tagged Clear Leave a comment
OMG – I forgot SAVE…
“I started a new workbook. Worked so hard to create a report from scratch. Meanwhile I opened many other workbooks to get the data I needed. Then I realized that too many workbooks were opened. I closed some of them … Continue reading
Posted in Excel Basic Tagged AutoRecovery Leave a comment
First thing to do when switching from Excel 2003 to 2007/2010
is to know where are the old menus and toolbar icons!!! I guess there are still a lot of of Excel 2003 users in Hong Kong, mainly in workplaces. No idea if it is also common in other cities. There are … Continue reading
Posted in Excel Basic Tagged QAT, RIBBON Leave a comment
When unhide row doesn’t work…
This above video was made just recently. You may read this post to understand more. Note: Please turn on CC for English subtitles. Hidden rows cannot be unhidden? Why? Although today is April Fools’ Day and the question sounds like … Continue reading
Posted in Excel Basic, Excel Tips Tagged Hide, Hide and Seek, Unhide 165 Comments
Excel Basic – Sum vs. “+”
+ – x / would be the four basic operators you learned in Excel basic. When you learned to use SUM instead of +, did you ask yourself or your teacher why? 1) SUM is much easier to input and … Continue reading
Posted in Excel Basic, Formula Tagged SUM 9 Comments
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:
Posted in Excel Basic, Excel Tips Tagged Arrange Windows, View Leave a comment
How to navigate cell in “Z” direction?? Tab Tab Tab Enter
Have you ever thought of how nice would it be if you can navigate cell in a “Z” direction?
Posted in Excel Basic Tagged Tab 4 Comments
Use Format Painter to decorate your spreadsheet
Christmas is all around. Perhaps you are busy with decorating your Christmas tree with lots of joy. However it’s no joy to decorate your Excel worksheets in your daily work. It could be really time-consuming to apply the same set … Continue reading
Posted in Excel Basic, Format Tagged Excel Basic, Format Painter Leave a comment
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
Posted in Excel Basic, Excel Tips Tagged Info 2 Comments
Excel Basic – Looks can be deceiving
Once upon a time, I was questioned about the accuracy of calculation in Excel just because one saw a formula “3% x 100” (A1*B1) yielding a result of 2.5 (C1). WHY???? As a basic but important rule, DO NOT trust … Continue reading
Posted in Excel Basic Tagged Format 1 Comment