Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Viewed vs printed margins

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Viewed vs printed margins

Resolved · Medium Priority · Version 2007

Reply Thu 17 Feb 2011, 09:42Delegate Emma said...

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

For upcoming training course dates see: Pricing & availability

Reply Mon 21 Feb 2011, 09:58Trainer Simon said...

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

Reply Mon 21 Feb 2011, 10:06Delegate Emma said...

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...

Reply Mon 21 Feb 2011, 10:18Trainer Simon said...

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.

Regards

Simon

Reply Wed 20 Apr 2011, 14:17Trainer Simon said...

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

Regards

Simon

Excel articles

· How To Create A Data Table In Excel 2010
· The Best Way To Use Clip Art Images In Excel
· Chart Creation Simplified - in 4 Simple Steps
· Creating A Clearer Picture With Excel
· How to start using Excel 2007 Functions

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips