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.
|
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.
|
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.
|
Excel question - No FM2R
