Adding Continuous Page Numbers While Printing

Excel offers a number of options for printing continuous page numbers. • When printing from one sheet, enter a number in the First page number bo...

Hiding Cells before Printing in Excel 2007

To hide cells containing values/text before printing, use one of the following techniques: Hiding a column(s) and/or row(s): To hide a column(...

Protecting Workbooks with a Digital Signature in Excel 2007

To set a Digital Signature: 1. Select File -> Finish -> Add a Digital Signature. 2. To get a digital ID or create your own digital ID click ...

Adding Passwords to Prevent Unauthorized Opening of a Workbook in Excel 2007

To enter a password: 1. Select File -> Save as. 2. Click Tools button, select General Options. 3. In General Options dialog box, enter passwor...

Protecting a Workbook in Excel 2007

Why it is important to protect a workbook? To prevent the structure from being changed. To prevent sheets from being deleted. To prevent new she...

Protecting Workbooks with a Digital Signature

MS-Excel 2013 allows you to add the digital signature to the workbook files. After checking the spreadsheet and verifying all the details, with the di...

Preventing Hidden Sheets from Appearing

When a sheet is hidden and the workbook is not protected, it will still appear in the list of hidden sheets in the Unhide box (from the Format menu, s...

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.