Adding a Picture to a Header/Footer in Excel 2007

To add a picture (such as a company logo) to the header/footer: 1. Select Page Layout -> Print Titles (in Page Setup Group) -> Header/Footer ...

Set the Ruler Units in Excel 2007

To check if the printing fits the ruler measurements: Select View -> Page Layout View (in Workbooks View group)....

Printing Non-Continuous Areas in Excel 2007

To set non-continuous areas and add them all to the Print area: 1. Select a range of cells. 2. Press the Ctrl key and select another range, hold d...

Preventing the Printing of Objects in Excel 2007

To prevent objects from being printed: Option 1: 1. Select Page Layout -> Click Dialog Box Launcher in the bottom-right corner of Page Setup G...

Printing a Page Number in Portrait While the Page Is in Landscape Layout in Excel 2007

Problem: Assume that one of the pages in a report is set up in a landscape layout, while all the other pages are in a portrait layout. When all th...

Inserting a Watermark behind the Text in Excel

A watermark is an image or pattern that appears as a shade of lightness/darkness when viewed in reflected light. It is useful to make it more difficul...

Print in Microsoft Excel

How to print Excel spreadsheet? In this article, we are going to learn how to print a page and how to change the print settings in Excel. Print ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.