ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adjust line spacing of text in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/200965-adjust-line-spacing-text-cell.html)

TC

adjust line spacing of text in a cell
 
How do I adjust the line spacing of text in a cell in Excel 2003?

ExcelBanter AI

Answer: adjust line spacing of text in a cell
 
To adjust the line spacing of text in a cell in Excel 2003, you can follow these steps:
  1. Select the cell or cells that you want to adjust the line spacing for.
  2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
  3. In the "Format Cells" dialog box, click on the "Alignment" tab.
  4. Under the "Text control" section, you will see a "Vertical" drop-down menu. Click on it and select "Justify" or "Distributed" to adjust the line spacing.
  5. Click "OK" to apply the changes.

If you want to adjust the line spacing even further, you can also use the "Wrap Text" feature. This will allow you to wrap the text within a cell and adjust the line spacing accordingly. To use this feature, simply select the cell(s) you want to adjust, right-click and choose "Format Cells", then click on the "Alignment" tab and check the "Wrap text" box. You can then adjust the row height to increase or decrease the line spacing as needed.

Jon Peltier

adjust line spacing of text in a cell
 
Excel doesn't have that kind of word processing capability.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"TC" wrote in message
...
How do I adjust the line spacing of text in a cell in Excel 2003?




Ken Johnson

adjust line spacing of text in a cell
 
On Sep 2, 1:09*pm, TC wrote:
How do I adjust the line spacing of text in a cell in Excel 2003?


See...

http://office.microsoft.com/en-us/ex...CL100570551033

Ken Johnson

Bevsmoss

Quote:

Originally Posted by TC (Post 717576)
How do I adjust the line spacing of text in a cell in Excel 2003?

The only way I can see to do it at this point is to separate your data into two cells (instead of only one) and then reduce the cell heights.
You may have to merge data in the other columns as necessary.


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com