Excel 365 text wrap issues, and page layout view vs print preview view issue

[John_F_at_AC]

1. Page Layout View...Unmerged cell, text set to wrap, alignment set up to top and left...text doesn't fill width of cell (see attached image 'Excel Questions File - item 1.jpg").

2. Page Layout view doesn't match print preview view. How do I get these to match? And...neither look correct (see attached image "Excel Questions File - item 2.jpg")

3. Print Preview View/ and printed PFD...Unmerged cell, text set to wrap, alignment set up to top and left...cell height not adjusted to text (see attached image "Excel Questions File - item 3.jpg").

Mostly new to using Excel...appreciate any input.

John

[#2]

@John_F_at_AC 

It's not really clear why what you're experiencing--differences between different views--is a problem. Excel is adjusting to the circumstances and different views, print settings. But it isn't "wrong" per se, is it. Just different.

If you have a specific layout in mind, specific words you want on one line, not on the next or prior, let us know. But this looks like a legitimate estimate sheet for a work project as is.

Or am I missing something?

[#3]

@mathetes

The file will function as is...it's not a problem, more aesthetics I guess. Was just looking for a solution to the issues presented...why the text wrap feature doesn't work properly, and why there isn't a view available that actually matches what will be printed. 

Specific layouts?

Item 1 - Have the indicated text fill the column width and wrap.

Item 2 - Have the layout view match the actual printed view/ print.

Item 3 - Have the indicated text fill the column height and wrap.

Just thought i was doing something wrong. If there's no solution, so be it.

Appreciate the input.

John

[#4]

Having the same issue. Have you found any work around?

[#5]

@Manisha327 ...

No...other than trying to use Word instead. Excel is for for numbers, Word is for words....they should rename Excel to "Number".

[#6]

New here, but had the same issue but couldn't find a solution anywhere online. I found out that if I change my zoom to 110% in Excel, it wrapped exactly the same on the screen as print preview and the actual print job (to PDF). I'm using Calibri 11, so I'm not sure if different fonts react differently. I'm also using merged cells, word wrap, and the justify cell alignment. It also may be impacted by my monitor size and resolution, so 110% may not work for everyone, but you can experiment.

[#7]

@ratherbehome Thanks...will give it a try.