Viewing: Excel 2010

Disable autocomplete suggestion feature in Excel

Excel Auto Complete features automatically suggests a value based on previous entries. Similar to disabling auto fill feature, Excel provides option for disabling the autocomplete suggestion feature as well. So you turn off auto complete suggestion feature if you find it distracting.Listed below are the steps to disable autocomplete suggestion in Excel 2016, Excel 2013 […] Read More

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

A trick to flip a column upside down in Excel

Excel users can sort a column using the Sort feature available as part of Sort & Filter menu. But what if you want to flip a column upside down. Let us see this with an example column having some text values as shown below.We will not be able to apply sort feature directly on this […] Read More

How to clear content only in Excel

Microsoft Excel provides users with various formatting option such as Number, Currency, Date and time that can be applied to a cell. But if you have a scenario where you want to only clear the content of the excel sheet and to preserve the format applied to the cells then you can use Clear Contents […] Read More

Prevent users from adding new worksheet in Excel

Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to […] Read More

How to do a word wrap in Excel

In Excel 2016, 2013 and 2010 when the typed text is larger than the width of the cell the text entered will appear as single line of text. If you want to align this text to the width of the cell then you can use excel 2010 word-wrap feature. If you want to do the […] Read More

How to insert to current date and time in Excel

In Excel , you can insert date and time using different formulas. Listed below are the steps to insert date, date and time and time in Excel 2016, 2013, Excel 2010 and Excel 2007Navigate to the cell where you want to insert time and and press Ctrl + Shift + : keysAlso See: Disable conversion […] Read More

How to disable auto fill feature in Excel

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

Automatically insert decimal points in Excel

In this short tutorial, let us see how to automatically insert decimal points in Excel 2016, Excel 2013 and Excel 2010.If you have an requirement where you will be entering only decimal values in a column. And using Excel's automatically insert decimal points feature, you can specify the number of places after which you want […] Read More

How to change shape of comment box in Excel

The standard style of the comment box in Excel is a rectangular shape as shown below.Now let us see how to customize the comment box shape using the Change Shape option in Excel 2016 & Excel 2013.Step 1: Insert a comment in Worksheet by using right click context menu or the option available as part […] Read More

How to create a link between two worksheets in Excel

In this short beginners tutorial let us see the steps for creating a simple link between two worksheets in Excel 2016, 2013 and 2010. In Excel, two worksheets can be linked using the paste options.1. From Sheet1, Copy the cell value which needs to be linked with the other Sheet. This can be done by […] Read More

How to change date system for a workbook in Excel

Microsoft Excel allows users to change to 1904 date system (difference between 1900 and 904 date system) using the Excel Advanced Options. Listed below are the steps to change the date system in Excel 2016, 2013 and 2010Step 1: Click the File menu then select Options link.Step 2: In the Excel Options window, click Advanced […] Read More

Disable automatic conversion of hyperlink in Excel

Excel 2016, 2013 and 2010 have feature that automatically does a conversion of all web address in to hyperlinks. This conversion takes place as you complete typing the internet address. But if you want to turn off this feature then you can use the relevant settings available as part of Excel options.Step 1: Click the […] Read More

How to change default ruler units in Excel

The default ruler units in Excel 2016, 2013 and Excel 2010 is set to Centimetres and users can change this default units using the Settings available as part of the Excel options.Step 1: Click the File menu and select Options from menu list.Step 2: In the Excel options window, click Advanced tab and navigate to […] Read More

How to increase the default number of sheets in Excel

The default number of sheets for a new workbook is set to 1 in Excel 2016, Excel 2013 and Excel 2010. But Users are allowed to change the default sheet number using the Excel options.Step 1: Launch Microsoft Excel 2013 and open a workbook.Step 2: Click File menu and select options from the menu list.Step […] Read More

1 2 6

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