excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel 2007

resolvedResolved · Low Priority · Version 2007

Kevin has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel 2007

How do you select headers and footers.

RE: excel 2007 - Headers and Footers

Dear Kevin

Thank you for attending Excel 2007 courses. I hope you enjoyed the courses and benefited from it.

In Excel 2007 there is a new view called Page Layout. This view is very similar to your MS word page Layout view. The purpose of this view is to view your spreadsheet as they would appear on the printouts. So instead of switching from Print Preview and normal view you can easily view what will be printed on what page. To access the Page Layout View simply choose View tab on the Ribbon and then choose Page Layout.

The other advantage of this view is that you can easily insert and modify Headers and Footers in this view. When you are in this view you


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.09 secs.