ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vertical Indent in Excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/251839-vertical-indent-excel-2002-a.html)

Excel

Vertical Indent in Excel 2002
 
Please help me to create Vertical Indent in Excel 2000 or 2002
because the border line are very near to the text given in a table, it looks
very congested in the gap between lines and text when we use auto fit to rows
option.
there is any solution for this
please help me i want to know the option.

Gord Dibben

Vertical Indent in Excel 2002
 
No such feature as Vertical Indent.

You can use Alt + Enter to provide a line feed at top and bottom of cell.

Select a cell then hit Alt + Enter

Type the text you need then hit Alt + Enter then Enter.

This will give you a blank line at top and bottom.


Gord Dibben MS Excel MVP

On Thu, 24 Dec 2009 22:03:01 -0800, Excel
wrote:

Please help me to create Vertical Indent in Excel 2000 or 2002
because the border line are very near to the text given in a table, it looks
very congested in the gap between lines and text when we use auto fit to rows
option.
there is any solution for this
please help me i want to know the option.




All times are GMT +1. The time now is 02:12 AM.

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