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

Displaying zero values in Microsoft Excel

From the Tools menu, select Options, View tab. Unchecking the Zero values box prevents the digit 0 from being displayed on the worksheet. This optio...

Use the continuous page numbers technique in Report Manager in Microsoft Excel.

Problem There is no way to set the first page number or to number additional pages (for example, a page added from the Word program) so that it will ...

Unhide rows and columns by using Custom Views in Microsoft Excel

To quickly unhide hidden rows and columns, add a Custom View for the all cells in the sheet with the rows and columns unhidden.   ...

How to Insert Watermark in Excel

In this article we will learn how to insert watermark in Microsoft Excel 2010. Excel watermark is a common way of identifying files belonging to th...

Printing page number in the opposite direction in landscape layout page in Microsoft Excel

Problem What do you do if one of the pages in a report is set up in landscape layout, while all the other pages are set up in portrait layout? When a...

Preventing a Printed Area from Extending onto an Extra Page

A common problem that occurs while printing is when a small area wraps onto an extra page. For example, if you select a print area that includes colum...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube