Category Archives: Format

Display single letter Day of week in Excel

Is it achievable?  Not by formatting but formula. Advertisements

Rate this:

Posted in Format, Formula | Tagged , , , | Leave a comment

Remove gridline

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

Rate this:

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

Text Alignment – Distributed

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?

Rate this:

Posted in Format | Tagged , | 1 Comment

Text Alignment – Fill

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

Rate this:

Posted in Format | Tagged , , | 1 Comment

Text Alignment – Indent

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

Rate this:

Posted in Format | Tagged , | 2 Comments

Format part of a formula result… A workaround (non-VBA) solution

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

Rate this:

Posted in Excel Tips, Format | Tagged , | 6 Comments

Paint the Lily

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

Rate this:

Posted in Format, General | Tagged | 1 Comment

Time Conversion – How to convert 24hr input as 4-digit number into TIME in Excel?

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

Rate this:

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

Rate this:

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