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

Printing data from different sheets using VBA in Microsoft Excel

In this article, we will create a macro to print data from different sheets. We have different raw datas in two sheets and we want to customize print...

Printing a PivotTable Report

To print a PivotTable report: 1. Select one of the cells in the PivotTable report. 2. Press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to ...

Adding the Custom Views Icon to the Excel Menu Bar

To add the Custom Views box to the Excel Menu bar: 1. Right-click one of the toolbars, and select Customize from the shortcut menu. 2. In the Comm...

Hiding Gridlines on the Screen and When Printing

To hide gridlines on the screen: 1. From the Tools menu, select Options, and then select the View tab. 2. In Window options section, deselect the ...

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.