Emma has attended:
Excel Advanced course
Viewed vs printed margins
Hi!
We are writing a report on Excel - as the majority of it is numerical. However, in the parts where we wish to make comments etc, some cells are filled with text. When this happens the on screen view of how much text fits in the cell on each line is different to the print preview/printed version.
Is there any way to have the onscreen view be workable (not print preview), and show the same margins as it will keep when it is printed?
Thank you!
Emma
RE: Viewed vs printed margins
Hi Emma,
Thank you for your question.
Have you tried working in Page Layout View as it shows the margins?
Regards
Simon
RE: Viewed vs printed margins
Hi Simon
I have tried this but the printed version is still different in respect of how many words fit on a line etc...
RE: Viewed vs printed margins
Hi Emma,
Thank you for your response.
I will have a look at it today and see if I can suggest anything.
Maybe you could send me a copy of the spreadsheet so I can take a a clearer look at the problem.
If you would like to send me a copy, send it to sk@stl-training.co.uk.
Regards
Simon
RE: Viewed vs printed margins
Hi Emma,
I am just chasing up your question.
Is this question still active?
If it isn't could you please mark it as resolved.
If it is can you please send me a copy of the workbook to:
sk@stl-training.co.uk
Regards
Simon
