ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I right AND left justify to block text in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/9868-can-i-right-left-justify-block-text-excel.html)

wink53083

Can I right AND left justify to block text in excel?
 
I would like to insert text into an excel document and then right and left
justify the text so that all rows look like a block.

tjtjjtjt

How is the text going into Excel? Is it all in one cell?
You can Justify the contents of a cell with Format | Cells | Alignment and
set Horizontal to Justify.
You'd likely have to size the column to your liking. And you'd need to wrap
the text.

If it's not going into a cell (or cells), how is it being placed into the
file?

tj

"wink53083" wrote:

I would like to insert text into an excel document and then right and left
justify the text so that all rows look like a block.


wink53083

DUH -- I must be having a bad day -- how obvious! Thanks!

"tjtjjtjt" wrote:

How is the text going into Excel? Is it all in one cell?
You can Justify the contents of a cell with Format | Cells | Alignment and
set Horizontal to Justify.
You'd likely have to size the column to your liking. And you'd need to wrap
the text.

If it's not going into a cell (or cells), how is it being placed into the
file?

tj

"wink53083" wrote:

I would like to insert text into an excel document and then right and left
justify the text so that all rows look like a block.



All times are GMT +1. The time now is 07:08 PM.

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