A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Clean presentation is one of the marks of an Excel expert. If you know you’re good, why let sloppy presentation of your work ruin your perception?
Look at the table on the right. A list of 5 numbers has been presented in 5 different formats. While the data is not aligned in columns A, C and D in terms of the decimal point, data in columns B and E appears better. But, most people would think of the numbers in column in B sort of running into those in column C. Hence, column E seems to be that best choice for formatting such a data. Now, the question is “how to achieve this?”.
Thankfully we have Michael Alexander of http://DataPigTechnologies.com to show the way.
Select your data and choose the appropriate number format. You can select the number of decimal places as may please you.
Make sure your data is aligned to the right. To do this, keep your data selected and press the button highlighted in the image on the right. It can be found under the Home tab, within the Alignment section.
Now, let’s get to the final step. Select your data, right-click on it and choose “Format Cells…”. Now, under the Alignment tab, choose “Right (Indent)” for the Horizontal option and put in the indent number. This will normally be 1 or 2. And press “OK” and see the magic!
Well, Microsoft knows when you will discover this function, you are bound to fall in love with it. That’s why, they have created a much simpler way to access it. Under the Home tab, within the Alignment section, you have a button that increases the right indent. It has been shown in the image on the right.
It’s easy, very easy. And right in front of you. Try it out!
And… share this awesome tip with other Excel lovers.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide