Once your Excel dashboard is ready, you can tweak it further with the built-in theming engine. You can head to the Page ...

To set print titles, go to the "Page Layout" tab, click on "Print Titles," and in the "Rows to repeat at top" or "Columns to ...

1] Change page orientation using the Page Layout menu This is the easiest way to change the orientation of a page in Microsoft Excel.

As an example, the traditional View menu resides on a separate View tab in Excel 2007. This tab houses several view modes, such as Normal, Page Layout and Full Screen.