• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Excel 2013

How to recover a workbook in Excel 2013 and Excel 2010

May 29, 2015 by Admin 1 Comment

recycle files  folder

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.

image

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.

image

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.

image

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

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010, Office 2013 Tagged With: auorecovery, auto recover, Backup, Excel 2010, file location, time interval, Workbook

Change the default file location in Excel 2013 and Excel 2010

May 28, 2015 by Admin 1 Comment

DefaultFileLocation

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.

Change file location excel 2010

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

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010, Office 2013 Tagged With: Change file location, default file location, Excel 2010

Change undo limit in Excel 2013 and Excel 2010

May 22, 2015 by Admin 3 Comments

Undo

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

image

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

image

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.

Filed Under: Excel, Excel 2010, Excel 2013, Office 2010 Tagged With: Change limit, Excel 2010, Maximum, Undo History, Undo limit

How to change the decimal separator in Microsoft Excel

November 1, 2014 by Admin 15 Comments

Microsoft Excel 2013 and 2010 by default uses the system defined decimal separator. In Windows 8 and Windows 7 this option is defined under the Regional and Language Settings available under Control Panel.

Step 1: Right click on the bottom end corner of Window 8 system and select Control Panel from the menu list (In Windows 7, navigate to Control Panel).

Windows 8 Control Panel

Step 2: In Adjust your computer’s settings screen, click Clock, Language and Region option.

Windows 8, Clock Language and Region

Step 3: In Clock, Language and Region screen, click Change date, time or number formats under Region section.

Change date, time or number formats on Windows 8

Step 4: Click the Additional settings button in the Region window.

Additional Settings on Windows 8

Step 5: In Customise Format window, enter the new separator for Decimal Symbol. Then click Apply and Ok button to save the changes.

Customize Decimal Symbol in Windows

Microsoft Excel also provides users can customize the separator used for Decimals and Thousands using Excel Options. Listed below are the steps to change decimal separator in Excel 2013 and Excel 2010

Step 1: Click File menu and select Options from the menu list.

Step 2: In the Options screen, click the Advanced tab and navigate to Editing section.

Decimal Separator Excel 2013 and Excel 2010

Step 3: Under Editing section, un mark the check box with caption as “User system separators”.

Step 4: Now enter your new decimal separator under Decimal separator field. For this demo we are colon (:) as the decimal separator.

Step 5: Click OK to confirm and save the changes.

Use System Separators - Excel 2013 and Excel 2010 

Also See: How to change decimal separator on Mac OS X Lion

Filed Under: Excel, Excel 2010, Excel 2013, MS Office Tagged With: Change, Decimal Separators, Excel, Number Format, Override, Regional and Language, System

How to repair Microsoft Office 2013

October 12, 2014 by Admin Leave a Comment

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.

Access Control Panel on Windows 8

Step 2: In the Control Panel window, select Programs followed Programs and Features.

 

Windows 8 Program Features

Step 3: Then select Microsoft Office in the Programs list and click Change button available in the menu bar. You can also access Change button by right clicking on the selected Program.

Change Programs Installation
Step 4: In “Change your installation of Microsoft Office Professional Plus 2013” screen, select Repair radio option and click Continue.

Repair Microsoft Office 2013

This should do the necessary configuration and start repairing Office 2013

image

Repairing Microsoft Office Professional Plus 2013

Step 5: The following confirmation message will be displayed and you will asked to restart the system to reflect the changes.

image

Click Yes button to reboot the system.

Reboot Windows 8

Also See: How to repair Microsoft Office 2010

Filed Under: Excel, Excel 2013, Office 2013, Outlook 2013, Word 2013 Tagged With: Office 2013, Repair, Windows 8

How to make a workbook read only in Excel

September 8, 2014 by Admin 40 Comments

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

Protect Workbook in Excel 2013 and Excel 2010

Click on the Protect Workbook drop down arrow. This would display the following menu list

Mark workbook as final in Excel 2013 and Excel 2010

Click on the Mark as Final menu, the following dialog box would appear.

image

On selecting OK button the following confirmation box will be displayed.

Warning message when workbook marked as final in edited

By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file.

Also See: Different ways to protect workbook in Excel 2013

Filed Under: Excel, Excel 2010, Excel 2013, MS Office Tagged With: Excel 2010, Mark As Final, Office 2010, Read-only, Workbook

  • « Go to Previous Page
  • Go to page 1
  • Go to page 2
  • Go to page 3

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023