How to increase number of worksheets Excel

Microsoft Excel by default contains 3 worksheets while creating a new Workbook. For creating a new workbook you can specify the number of Worksheet that a Workbook needs to contain. This can be modified using Excel Options. Listed below are steps for increasing number of Worksheets for a new Workbook in Excel 2013, Excel 2010 […]

How to recover a workbook in Excel 2013 and Excel 2010

This tutorial explains the auto recover feature available in Excel 2013 and Excel 2010. The auto recover feature regularly takes a backup of the workbook and stores it in a pre defined location. This feature is useful if Excel suddenly crashes and you want to recover the working copy. Document Recovery A document recovery pane […]

How to make a workbook read only in Excel

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010 Click on the File menu –> Info menu Click on […]

How to hide header/footer while typing in Excel 2010

This is in response to question asked by a reader of this blog related with header and footer in Excel 2010. how do I make the header / footer not visible on the page while typing? When you click on the insert header and footer option in Excel 2010, excel would immediately change the view […]

How to password protect workbook in Excel Mac 2011

Excel for Mac 2011 users can password protect the workbook using the option provided as part of the File menu. Click the File menu and select Passwords from the displayed menu list. This would display the following File Passwords window with different password option. You can set a password for opening the excel workbook using […]