- 1,862,235 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- How to sort bar chart in descending order?
- Perform VLOOKUP with 2 lookup values
- 2D SUMIF with two variables – one on column and one on row
- Sequential number for visible rows only
- Dropdown calendar in Excel
My YouTube Channel
- My Tweets
Tag Archives: Format
If you know Format Painter, the on top of your mind solution should be using Format Painter to copy Chart Formats to other charts. However, it doesn’t work… 😦 No worries. Copy and Paste comes to recuse!! Really?!
Don’t be shy! Let silly things continue! Let’s Hide and Seek with #Excel again! 🙂 Case 1 Case 2 Case 3 You may download a Sample File – Hide and Seek Cell Content for the above cases. If you know the … Continue reading
Making cell border in #Excel should be something real basic. However some people may have found it frustrating / confusing to play Hide and Seek with borders just hoping that they will be displayed in the way they want it. … Continue reading
Does it sound familiar to you? Are you using Excel as word processing tool? If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet … Continue reading
Is it achievable? Not by formatting but formula.
You probably knew it… when we make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1. Put it in other words, if the number format of A1 is … Continue reading
This title sounds a bit silly, but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading
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
Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂
We talked about examples of using “Text Alignment – Indent” in the previous post. In the coming posts, let’s talk about the rest of the less commonly-used text alignments. Actually, I find it a bit challenging to cite real-life examples … Continue reading
How to format part of a formula result? In a normal text string, we may format part of the text to highlight a specific information. For example, if we input the text string “Today is Thursday, 01/05/2014” in A1, we … Continue reading