Computer Related > Excel question Computing Issues
Thread Author: MD Replies: 2
View Threaded 

New Fri 15 Feb 19 11:19 
 Excel question - MD
Another Excel question.

I want to print out several sheets and there are quite a few words in each cell. On the screen it all fits, but when I go to print you can see where it will be compressed, say half of the bottom line of text is half missing vertically. Not in all cases, but some. What would be the ideal/correct formats for those cells so that it all sows correctly when printed. Thanks in advance.

P.S. The formatting currently is (Number) General. (Alignment) Justify Centre.
Reply to this message | Report message
       
New Fri 15 Feb 19 12:35 
 Excel question - No FM2R
I don't know. I would have to fiddle about with it to work it out and I'm not clear exactly what you need..

However, a starting point is that you should format the cell as text. Consider whether or not you want it to wrap text, and also consider using "Merge and Center" to force it to spread across a number of cells and not need to wrap at all.

if you could email me an example so that I can get a better idea of what you're after achieving, that would help.

M.




Reply to this message | Report message
       
New Fri 15 Feb 19 13:20 
 Excel question - zippy
What Mark said.

Also, if you are using 2007+ try using page layout mode (thee boxes on the bottom of the screen to the left of the zoon tool - it's the middle icon).

It may help you to see how the page is going to look as you enter the data.




Reply to this message | Report message
       
Latest Forum Posts