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...
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 ...
To quickly unhide hidden rows and columns, add a Custom View for the all cells in the sheet with the rows and columns unhidden. ...
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...
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...
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...
In this article, we will learn How to Hide errors before printing in Excel. Scenario: Errors in excel shows there is some problem in formula...
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.
