microsoft excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel 2007

Microsoft Excel 2007

resolvedResolved · High Priority · Version 2007

replyReply Tue 9 Nov 2010, 16:46Delegate Jayshree said...

Jayshree has attended:
Excel Introduction course

Microsoft Excel 2007

Not very sure of page layout - can you please explain ?

For upcoming training course dates see: Pricing & availability

replyReply Wed 10 Nov 2010, 17:44Trainer Rodney said...

RE: Microsoft Excel 2007

Hello Jayshree,

Hope you enjoyed your Microsoft Excel course with Best STL.

Thank you for your question regarding Page Layout. I'm not which part of the 'Page Layout' ribbon you are not sure about. Some of these sections are covered in our Intermediate training course.

There are five sections to consider.

1) The first is the 'Themes' section any one of which you can apply to any data lists you have developed.

2) The second section is the 'Page Setup' where you can change magin settings, change the page to Landscape from Portrait and change the page size. You can also set a print area for printing and insert page breaks if required. Here you can change the page background and set print titles if necessary.

3) The 'Scale to Fit' section allows you to adjust page sizes etc.

4) In the 'Sheet Options' section you can decide to view/print gridlines and/or headings.

5) If you have any objects within a worksheet the 'Arrange' section gives you the ability to modify certain aspects of these objects.

I suggest you create a small spreadsheet and try out each one of these sections. It won't take long for you to master each aspect.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

 

Please browse our web site to find out more about
excel classes 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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard