ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Indent text in cell (https://www.excelbanter.com/excel-discussion-misc-queries/198520-indent-text-cell.html)

RSunday

Indent text in cell
 
When printing a spreadsheet with text in the cells, sometimes text gets cut
off - this can be avoided by using "device font" - but that is a manual
procedure and depends on the printer. A better way would be to have all text
indented from the cell borders.

Using the indent feature for the cell format only allows to do it in both
sides if the text is centered and evenly distributed. I would like the text
to be left aligned, and I would also like the indentation to be at the top
and the bottom as well.

Is there a way to do that?

May use thick transparent borders or something...? Any suggestions are
appreciated.

Kevin B

Indent text in cell
 
Select the cells you wish to indent and click FORMAT in the menu and select
CELLS and set the INDENT spinner box to the indent value. Each unit of
measure in the spinner is equal to the width of a single character
--
Kevin Backmann


"RSunday" wrote:

When printing a spreadsheet with text in the cells, sometimes text gets cut
off - this can be avoided by using "device font" - but that is a manual
procedure and depends on the printer. A better way would be to have all text
indented from the cell borders.

Using the indent feature for the cell format only allows to do it in both
sides if the text is centered and evenly distributed. I would like the text
to be left aligned, and I would also like the indentation to be at the top
and the bottom as well.

Is there a way to do that?

May use thick transparent borders or something...? Any suggestions are
appreciated.



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

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