- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Advanced vlookup - wildcard characters "?" and "*"
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - Text vs. Number
- 2D SUMIF with two variables – one on column and one on row
- Copy data from strictly-protected sheet
- Show number in thousand (k) or in million (M) by using custom format
- Convert an 8-digit number into Excel-recognizable Date
Category Archives: Format
Is it achievable? Not by formatting but formula. Advertisements
By default, gridline is not printed on paper. Nevertheless, I would usually remove gridline when I submit my report, or paste part of a spreadsheet into PowerPoint or Word. Why? Simply for better look and feel. See the screenshots below to … Continue reading
Let’s continue the topic of uncommonly used text alignment. This time, it’s Distributed. Honestly, another format rarely used in my work life. So what is it about?
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
There are different types of (horizontal) text alignment in Excel. Most people know about (and use mainly) General, Right, Center, Left. But are you aware of Indent, Fill, Justify, Centre Across Section and Distributed? Let’s talk about Indent this week. … 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
Well, this is not an Excel post. This is something about Visual Presentation at a glance, so I think it’s sort of related to Excel. 🙂 One day, I visited a Japanese Fast Food Restaurant and saw the above sticker … Continue reading
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