Viewing: Workbook

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 […] Read More

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 […] Read More

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 […] Read More

How to see and update workbook properties in Excel 2013

This tutorial is about the steps to see and update workbook properties in Excel 2013. Launch Excel 2013, click File menu and select Info from the menu list. In the Info screen navigate to Properties section available on the right hand side. The Properties panel will display details such Size, Title, Tags, Categories, Date and […] Read More

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 […] Read More

How to change default number of worksheet in Excel 2011 Mac

The number of worksheet associated with a new workbook in Excel 2011 for Mac is 1. And if your work requires adding a worksheet then you can click the plus sign to insert new sheet. If you always require minimum of 3 worksheet in your new workbook then it is recommended to change the default […] Read More

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 […] Read More

How to unprotect a sheet in Excel 2010

We have already discussed about protecting a workbook structure and preventing users from adding new Worksheet. In this tutorial we will find out to unprotect a Workbook. When you navigate to the Info menu of a protected Workbook, it will display that the structure of the workbook is locked. You can remove this protection by […] Read More

How to change the number of sheets in Excel 2010 Workbook

In Excel 2010, the default number of worksheets included in a new workbook is 3.  We have already seen how to change the number of worksheets in Excel 2007. Similarly using Excel 2010 options the number of sheets can be increased on decreased. Click on the File menu –> select options link   In Excel […] Read More

Get your free copies of the following tech guides by joining the Digital Answers mailing list.