Excel 2010

How to Insert, Delete, Customize Comments in Excel

July 22, 2015 By Ravi Shankar 8 Comments

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial.

How to insert comment
Customize the comment box
Navigate between Comments
Delete Comment

How to insert comment

Excel allows users to insert comment using the options available as part of the Review menu. But if you want to quickly insert then right click on the cell and select Insert Comment from the listed menus.

Customize Comment

A typical comment box in Excel is as shown below.

In order to change the name that appears on the Comment box, click on the File menu then the Option link then in the General tab, navigate to Personalize your copy if Microsoft Office and enter your desired name in the User name box. Click OK button to save the changes. Now the entered name will appear when you Insert new Comments.

Similarly if you want to change the Font Style used in Comment box then select then right click on the Comment box and select Format Comment menu option.

The Format Comment window allows you change the Comments Font Style.

Navigate between Comments

If you have more than one comment inserted in the Excel worksheet and you want to navigate between the comments then you can use the menu options available as part of the Comment section under Review menu. The list option includes Show All Comments, Previous and Next.

Delete Comment

A Comment can be quickly deleted are hidden by right clicking on the cell and selecting the required menu option. You can also use the menu option available as part of the Comments section under Review menu.

By this way you can Insert, customise, navigate and delete comments in Excel 2013 and Excel 2010

How to recover a workbook in Excel 2013 and Excel 2010

May 29, 2015 By Ravi Shankar 1 Comment

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 will be displayed on the left hand side of the Excel worksheet when excel is opened after a crash.This would contain the workbook(s) which were kept open during the crash.

If you want to recover any of the displayed workbook, then select the required file from the available files list.

Change AutoRecover file location

You can specify the path for auto recovery feature using Save workbooks Options. Click the File menu then Options link and then navigate to the Save tab.

Again navigate to the Save workbooks section in Save Options screen. Using AutoRecover file location you can specify the path for automatic backup.

Change AutoRecover Time interval

Using Save AutoRecover information spinner field you can increase or decrease the minutes at which the auto save needs to happen.

Disable AuoRecovery

We have seen the importance of AutoRecovery feature in Excel and by default this is enabled. But Excel also provides option for disabling this feature.

You can disable this by navigating to AutoRecover exceptions section then un tick the checkbox with label as Disable AutoRecover for this workbook only.

Any changes made to this would get reflected after clicking on the OK button available at the bottom of the Save options screen.

del.icio.us Tags: Excel 2010,auto recover,auorecovery,workbook,backup,file location,time interval

Change the default file location in Excel 2013 and Excel 2010

May 28, 2015 By Ravi Shankar 1 Comment

We have already seen the following articles on Microsoft Word 2010 and Microsoft PowerPoint 2010.

How to change default file location in Word 2010.
How to change default file location in PowerPoint 2010.

In this tutorial we are going to see how to change the default file location in Microsoft Excel 2013 and Excel 2010.

Click the File menu on Microsoft Excel and then the options link.

In the Option window, navigate to Save workbooks section under Save option. Windows Vista and Windows 7 operating system will have the default file location set to their users document folder. Now change this to your preferred working folder by making the necessary changes to Default file location property. After making the change, click Ok button to confirm and save the changes.

del.icio.us Tags: Excel 2010,default file location,Change file location

Change undo limit in Excel 2013 and Excel 2010

May 22, 2015 By Ravi Shankar 3 Comments

As per the Excel Specifications and limits the maximum limit for undo in Excel 2010 is set to 100. In the previous version of Excel this was set to 16. The maximum limit value is fixed but you can increase or decrease this limit by modify registry settings.

Please Note:- Changing Registry Settings is not recommended and do this with at most caution while trying these changes.

To change the undo maximum limit, Open Windows Registry Editor and then navigate to the following path

HKEY_CURRENT_USER –> Software –> Microsoft –> Office –> 14.0->Excel->Options

Create a new DWORD value with the key name as UndoHistory

Then modify UndoHistory by setting the Base as Decimal and value as 16. Click the OK button to save the changes.

This would decrease the number of undo same as the previous of Excel. You can also increase the undo limit from 100 to 200 for Excel 2010 by changing the above created Windows Registry key.

Changing column width in excel 2013 and excel 2010

May 4, 2015 By Ravi Shankar 1 Comment

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 of text entered in the Cell. The mouse pointer needs to placed on the border line before doing a double click

Using Mouse Drag and Drop

Another way for changing the column width is to use mouse drag and drop feature and adjust the cell column width depending upon the requirement.

Using Format menu option

Excel also provided option for changing the column width by using the Format menu option. In the home menu, navigate to Cells section and click the drop down arrow below the Format menu option.

This would display the following list of available menus.

To Change the column width of the selected cell, select Column Width from the available menus and enter the desired column width for the cell in Column width text box.

And if you want to change the width for all the columns in the Worksheet then select Default Width menu from Format menu option and specify the Standard Width in Standard column width text box.

How to enable a disabled add-in in Excel 2010

December 27, 2014 By Ravi Shankar Leave a Comment

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 Add-Ins options.

Select Disabled Items in the Manage dropdown and click the Go button. This would display the following Disabled Items window using which you can see and also re-enable the disabled add-in. You can select the ones you wish to re-enable and click the Enable button.

How to enable or disable multi threading feature in Excel

September 9, 2014 By Ravi Shankar Leave a Comment

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 menu and select Options from the list.

Step 2: In the Options window, click Advanced tab and scroll down to Formulas section.

Step 3: Now you can enable or disable multi threading feature by using the checkbox with label Enable multi-threaded calculation. This also provides option for specifying the number of processor that has to be used for the calculation. By this way Excel users can turn on or off multi threading feature.

Also See: How to turn off auto calculation in Excel 2010

How to make a workbook read only in Excel

September 8, 2014 By Ravi Shankar Leave a Comment

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