Changing column width in excel 2013 and excel 2010

There are different ways for changing the column width of cell in Excel 2010 and Excel 2013. Some of them are listed below Double Clicking Column Header The easiest one for adjusting the column width is to double click the Column Header of cell whose width needs to be changed depending on the longest length […]

How to enable a disabled add-in in Excel 2010

Office products such as Word, Excel Outlook will automatically disable installed add-in if any add-in prevented the software from functioning correctly. And it also provides option for enabling the disabled add-in items. In Excel 2010 you can enable a disabled add-in using the add-in options. Click the File menu –> Options link –> Navigate to […]

How to use Goal Seek in Excel

Microsoft Excel has a Goal Seek feature which can be used to derive value of a cell based on the result set for the cell containing a formula. Let us see this with an example that does a simple addition. In the below screenshot, you should notice that the sum of A3 to E3 is […]

How to repair Microsoft Office 2013

This tutorial provides step by step instruction to repair Office 2013 products like Word 2013, Excel 2013, Outlook 2013 etc.. When you encounter problems with your Microsoft Office 2013 installation, then you can try these steps. Step 1: Right click on the Start menu and select Control Panel from the menu list. Step 2: In […]

How to enable or disable multi threading feature in Excel

Microsoft Excel 2010 has a multi threading feature which when enabled reduces the time taken for complex calculation or Formulas. And you can enable this feature when your computer supports multi processing capabilities. Listed below are the steps to enable or disable multi threading feature in Excel 2013 and Excel 2010 Step 1: Click File […]

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