#1   Report Post  
Old October 22nd 09, 10:39 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
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  
Old October 23rd 09, 12:58 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
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  
Old January 5th 21, 08:24 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
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) 2 March 24th 08 10:09 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 04:33 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017