Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Danny
 
Posts: n/a
Default


It wraps, right, it wraps over the viewport, in this case, the screen,
now, the printer is another viewport, a hard-wrap and a soft-wrap are not
the same and the printer uses different stdout, so, as the other fella
said, use alt-Enter to put a hard-wrap, or, an actual line-feed the
printer can use.

Danny


On Mon, 11 Jul 2005 06:51:03 -0700, Cageyslick
wrote:


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
  #2   Report Post  
Cageyslick
 
Posts: n/a
Default A 2 line text showing up in the Cell in Excel prints in 1 line

When I type in text in a Cell in Excel, and wrap it, it fits in 2 lines. When
I print it, it prints in one line, leaving the other line as blank space. I
could not figure out what is the problem. This also happens for 3 or more
lines....when it prints in one line lesser than what it shows up in the Cell
on the computer
  #3   Report Post  
abcd
 
Posts: n/a
Default

try with other fonts and see if it changes anything

The fonts (event true fonts) do not exactly print at the same width :
they gives different results on screen and on printer.

Some of them as big width difference, some others only a small one.
  #4   Report Post  
RagDyeR
 
Posts: n/a
Default

You can *force* the line to break at a particular place by using
<Alt <Enter

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Cageyslick" wrote in message
...
When I type in text in a Cell in Excel, and wrap it, it fits in 2 lines.
When
I print it, it prints in one line, leaving the other line as blank space. I
could not figure out what is the problem. This also happens for 3 or more
lines....when it prints in one line lesser than what it shows up in the Cell
on the computer


  #5   Report Post  
Cageyslick
 
Posts: n/a
Default

Well the problem is that when I force it to break a line, there is a large
space left before the cell width ends after the place where I force a break.
When it prints, it makes no sense that a small word which could have been
easily accomodated in the same line is taking another line while there is so
much blank space left on the previous line. I am using Verdana 8.0 size, I
also tried Arial 8.0 but its the same problem. It shows the problem in Print
Preview itself. You dont need to send it to a printer to see.

"Danny" wrote:


It wraps, right, it wraps over the viewport, in this case, the screen,
now, the printer is another viewport, a hard-wrap and a soft-wrap are not
the same and the printer uses different stdout, so, as the other fella
said, use alt-Enter to put a hard-wrap, or, an actual line-feed the
printer can use.

Danny


On Mon, 11 Jul 2005 06:51:03 -0700, Cageyslick
wrote:


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/



  #6   Report Post  
Cageyslick
 
Posts: n/a
Default

Well the problem is that when I force it to break a line, there is a large
space left before the cell width ends after the place where I force a break.
When it prints, it makes no sense that a small word which could have been
easily accomodated in the same line is taking another line while there is so
much blank space left on the previous line. I am using Verdana 8.0 size, I
also tried Arial 8.0 but its the same problem. It shows the problem in Print
Preview itself. You dont need to send it to a printer to see.

"RagDyeR" wrote:

You can *force* the line to break at a particular place by using
<Alt <Enter

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Cageyslick" wrote in message
...
When I type in text in a Cell in Excel, and wrap it, it fits in 2 lines.
When
I print it, it prints in one line, leaving the other line as blank space. I
could not figure out what is the problem. This also happens for 3 or more
lines....when it prints in one line lesser than what it shows up in the Cell
on the computer



  #7   Report Post  
RagDyer
 
Posts: n/a
Default

Start over, from the beginning, and adjust the length of *each* line with
<Alt <Enter.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Cageyslick" wrote in message
...
Well the problem is that when I force it to break a line, there is a large
space left before the cell width ends after the place where I force a

break.
When it prints, it makes no sense that a small word which could have been
easily accomodated in the same line is taking another line while there is

so
much blank space left on the previous line. I am using Verdana 8.0 size, I
also tried Arial 8.0 but its the same problem. It shows the problem in

Print
Preview itself. You dont need to send it to a printer to see.

"RagDyeR" wrote:

You can *force* the line to break at a particular place by using
<Alt <Enter

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Cageyslick" wrote in message
...
When I type in text in a Cell in Excel, and wrap it, it fits in 2 lines.
When
I print it, it prints in one line, leaving the other line as blank

space. I
could not figure out what is the problem. This also happens for 3 or

more
lines....when it prints in one line lesser than what it shows up in the

Cell
on the computer




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
cell to auto adjust to fit text in excel 02 Keith Excel Discussion (Misc queries) 0 May 12th 05 05:04 AM
Remove the apostrophe (') in Excel cell text values Connull Excel Discussion (Misc queries) 5 January 11th 05 06:06 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
How can I asign a number value to a text line in Excel? AIF_GoofyDo2 Charts and Charting in Excel 0 December 6th 04 02:19 AM
Forcing text onto new line in cell Doug Poll New Users to Excel 2 December 3rd 04 01:09 PM


All times are GMT +1. The time now is 01:28 AM.

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"