Indenting text in cells without adding spaces

There are times you will have a column of text immediately to the right of a column of numbers they both look squashed.

Too many people insert spaces at the beginning of each of their text entries to provide some ‘white space’. There are various reasons why this is not the best option, including the fact that it is very time consuming.

There is a much easier way easier way to achieve the same result by formatting the cells.

• Select the cells that contain the data you want indented;
• From the Format menu select Cells;
• Click on the Alignment tab and select Left (Indent) from the Horizontal dropdown list.
  On the Indent spinner box set the number of spaces you want to insert between the start of your text and the left edge of the the column;
• Click OK and you’re done.

Create multi line entries in a Microsoft Excel cell by pressing the Alt and Return keys. This inserts a line break at that point in the text.

Great for controlling how the text in cells will appear. For example, for inserting addresses into spreadsheets as it avoids having addresses in multiple cells and makes mail merging addressing dead easy.

This is different from word wrap which scrolls text on the next line depending on the size of the cell. By using Alt + Rtn you determine where the line break comes.

Ctrl+Shift+%

As easy as that! This keyboard short cut will format the selected cells as percentages to 2 deciamal places. It is the same as clicking the % button on the format toolbar, but much quicker