ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text not fully displayed when text direction changed (https://www.excelbanter.com/excel-discussion-misc-queries/57379-text-not-fully-displayed-when-text-direction-changed.html)

Mikey9131

Text not fully displayed when text direction changed
 
I've got a worksheet where most of the text is displayed as usual, reading
left to right. I've changed some cells so text direction is -90. When I type
into these cells the first part of the first word is partly hidden. It's a
bit irritating since the text displays normally in "print preview" and prints
correctly - it just doesn't display correctly on the screen. Any help would
be gratefully appreciated

Gilles Desjardins

Text not fully displayed when text direction changed
 
A shot in the dark: Remove any formatting (left, center or right justified)
by un-selecting their respective buttons.

Gilles

"Mikey9131" wrote in message
...
I've got a worksheet where most of the text is displayed as usual, reading
left to right. I've changed some cells so text direction is -90. When I
type
into these cells the first part of the first word is partly hidden. It's a
bit irritating since the text displays normally in "print preview" and
prints
correctly - it just doesn't display correctly on the screen. Any help
would
be gratefully appreciated




Mikey9131

Text not fully displayed when text direction changed
 
Thanks for the suggestion - tried it but it didn't work. Any more suggestions?

"Gilles Desjardins" wrote:

A shot in the dark: Remove any formatting (left, center or right justified)
by un-selecting their respective buttons.

Gilles

"Mikey9131" wrote in message
...
I've got a worksheet where most of the text is displayed as usual, reading
left to right. I've changed some cells so text direction is -90. When I
type
into these cells the first part of the first word is partly hidden. It's a
bit irritating since the text displays normally in "print preview" and
prints
correctly - it just doesn't display correctly on the screen. Any help
would
be gratefully appreciated





Gilles Desjardins

Text not fully displayed when text direction changed
 
OK, try: Format, Cells, Alignment, Center (horizontal), Center (vertical)

Gilles
"Mikey9131" wrote in message
...
I've got a worksheet where most of the text is displayed as usual, reading
left to right. I've changed some cells so text direction is -90. When I
type
into these cells the first part of the first word is partly hidden. It's a
bit irritating since the text displays normally in "print preview" and
prints
correctly - it just doesn't display correctly on the screen. Any help
would
be gratefully appreciated





All times are GMT +1. The time now is 09:47 PM.

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