• Skip to main content
  • Skip to primary sidebar

Excel Tips and Tricks

  • About
  • Privacy Policy

Excel

How to disable auto fill feature in Excel

November 9, 2015 by Ravi 15 Comments

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill in Excel 2013, Excel 2010 and Excel 2007

Excel 2016, 2013 and 2010

Click on the File menu –> Options link and navigate to Advanced tab on the left hand side.

enable or disable auto fill feature in Excel 2013 and Excel 2010

Under Editing options, un tick the check box with label as Enable fill handle and cell drag-and-drop. This will turn off the auto fill feature in Excel 2010.

Excel 2007

In Excel 2007, this feature can be turned on or off using the Excel Advanced Options.

Click on the Office button –> Excel Options

Excel 2007 Options

Under Excel Options select Advanced section

Turn off Auto fill in Excel 2007

By checking or un checking “Enable fill handle and cell drag-and-drop”, you can turn on or off the Auto fill feature in Excel 2007.

Also See: How to disable autocomplete suggestion feature in Excel 2010

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Auto fill, Disable, Enable auto fill, Excel, Turn Off

How to change the decimal separator in Microsoft Excel

November 1, 2014 by Ravi 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

Primary Sidebar

Recent Posts

  • How to increase number of worksheets Excel
  • A trick to flip a column upside down in Excel
  • Prevent users from adding new worksheet in Excel
  • Repeat action keyboard shortcut in Microsoft Office
  • How to import text file in Excel

Copyright 2020 © getexceltips.com