Monthly Archives: July 2014

Remove gridline

Posted on July 26, 2014 by MF

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 Grideline | Leave a comment

Remove Line Break instantly

Posted on July 19, 2014 by MF

Two different ways to replace Line Break with a space QUICKLY If you are trying to build a table of data which is analysis-friendly, DO NOT use line break in your fields and labels. Otherwise, you will create unnecessary steps … Continue reading →

Rate this:

Posted in Excel Tips | Tagged Line Break | Leave a comment

Input line break in a cell – ALT ENTER

Posted on July 12, 2014 by MF

In Word, it is so simple to input a line break by pressing Enter. However in Excel, pressing Enter will take you to the cell below. To input line break in Excel requires just a simple key combination. What you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged ALT ENTER | Leave a comment

Text Alignment – Distributed

Posted on July 5, 2014 by MF

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?