Category Archives: Excel Basic

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

Rate this:

Posted in Excel Basic, Formula | Tagged , , | 5 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

Rate this:

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

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | Leave a comment

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

Rate this:

Posted in Excel Basic | Tagged , | Leave a 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

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 3 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

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 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?  

Rate this:

Posted in Excel Basic | Tagged | 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

Rate this:

Posted in Excel Basic | Tagged | 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:

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 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

Rate this:

Posted in Excel Basic | Tagged | 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

Rate this:

Posted in Excel Basic | Tagged , | Leave a comment

When unhide row doesn’t work…

Hidden rows cannot be unhidden? Why? Although today is April Fools’ Day and the question sounds like an April Fool’s question, this post is not about to fool anyone.  Just another real case to share. For an unprotected sheet, hidden … Continue reading

Rate this:

Posted in Excel Basic, Excel Tips | Tagged , | 95 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

Rate this:

Posted in Excel Basic, Formula | Tagged | 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:

Rate this:

Posted in Excel Basic, Excel Tips | Tagged , | 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?

Rate this:

Posted in Excel Basic | Tagged | 2 Comments

Excel Basic – Calculation Options

Excel Bugs:  my worksheet does not calculate when I change the variable of a formula??? Don’t panic! It’s most likely that the Calculation Options has been turned to Manual. Calculation Options – Automatic vs Manual In Excel 2007 or above, … Continue reading

Rate this:

Posted in Excel Basic | Tagged | Leave a comment

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

Rate this:

Posted in Excel Basic, Format | Tagged , | 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

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 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

Rate this:

Posted in Excel Basic | Tagged | 1 Comment