Wednesday, August 28, 2013

How to Put White Space in Cells in Excel 2003


1. Click a cell that you wish to add white space.
2. Click the formula bar at the top of the screen.
3. Type the following in the formula bar: =' 'Substitute the exact number of spaces that you wish to add to the cell between the quotation marks.
4. Right-click the cell and click 'Copy' in the menu.
5. Highlight all cells that you wish to add white space.
6. Right-click the selection and click 'Paste' to add the blank spaces to all selected cells.

Blogger news