![]() |
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. |
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