Monthly Archives: July 2014

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

Remove Line Break instantly

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

Input line break in a cell – ALT ENTER

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 | 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