#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
Default Wrap Text

In the form I am creating all the entries show the "Wrap Text" as perfect.
Then in Print Preview it shows side-by-side and then prints that way?
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default Wrap Text

Which version of Excel?

What type of form?

How much data in an "entry"?

Maybe post some examples of your entries.


Gord Dibben MS Excel MVP


On Thu, 22 Oct 2009 14:39:02 -0700, Confused??
wrote:

In the form I am creating all the entries show the "Wrap Text" as perfect.
Then in Print Preview it shows side-by-side and then prints that way?


  #3   Report Post  
Junior Member
 
Posts: 27
Default

Quote:
Originally Posted by Confused?? View Post
In the form I am creating all the entries show the "Wrap Text" as perfect.
Then in Print Preview it shows side-by-side and then prints that way?
Try these steps while performing wrap text in Excel
In a worksheet, select the cells that you want to format.

On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)

Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.

Adjust the row height to make all wrapped text visible
Select the cell or range for which you want to adjust the row height.

On the Home tab, in the Cells group, click Format.

Under Cell Size, do one of the following:

To automatically adjust the row height, click AutoFit Row Height.

To specify a row height, click Row Height, and then type the row height that you want in the Row height box.

Let me know if this works for you!
Admin
O365CloudExperts
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get date/time to wrap (format - wrap text doesn't work)? Alex Excel Discussion (Misc queries) 3 April 4th 23 02:29 PM
Wrap text doesn't wrap [email protected] Excel Worksheet Functions 1 March 28th 07 01:58 AM
Why won't text in cell wrap. Cell format set to wrap. DRB Excel Discussion (Misc queries) 2 September 28th 06 08:27 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
text (3750 char.)truncates with text wrap and row heigh adjusted? Boydster Excel Discussion (Misc queries) 1 May 19th 05 05:59 PM


All times are GMT +1. The time now is 05:38 PM.

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

About Us

"It's about Microsoft Excel"