Microsoft Excel 2002

Use Smart Tag to fill series of dates in Microsoft Excel

New in Excel 2002 (xp) The Smart Tag lets you enter a series of dates automatically. You can enter an ascending series according to days, months an...

Copying & Pasting Cell Content Along with Formatting

In this article you’ll learn, how to copy and paste cell content along with the cell formatting in Microsoft Excel. Sometimes, we want to copy and ...

Hiding Errors in Cells Before Printing

To hide errors in cells before printing in Excel 97 and Excel 2000: 1. Select the Print Area in the Sheet, and from the Format menu, select Conditi...

Unprinted blank pages in Microsoft Excel 2002

Blank pages in the defined print area will not be printed in Excel 2002....

Adding non-contiguous ranges to a single contiguous range for printing in Microsoft Excel

In Excel 2000 and Excel 2002, you can join non-continuous ranges to form a single contiguous range in order to print them as a single print area. T...

Inserting a picture (company logo) in the header in Microsoft Excel 2002 xp

From File menu choose Page setup. Select the Header/Footer tab. Click Custom Header. Select Left area. Click the Picture icon (second from ...

Password to prevent opening a workbook in Microsoft Excel

New in Excel 2002 In Excel 2002, you can prevent the opening of a workbook by adding a password in the Security tab. From Tools choose Options, ...

Pasting Multiple Copied Ranges Using the Clipboard in Microsoft Excel 2010

The Clipboard in Excel is an extension of the Windows clipboard. It holds only the last item copied. Excel clipboard can hold up-to 24 different entri...

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