Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wink53083
 
Posts: n/a
Default 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.
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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.

  #3   Report Post  
wink53083
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"