Viewing: Excel

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

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

How to change the decimal separator in Microsoft Excel

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

Automatically remove duplicate rows in Microsoft Excel

Remove duplicates rows in Excel 2013 and Excel 2010 There would be many occasion where we would require to find duplicate rows in a given set of data. Excel 2010 provides a feature which can be used to automatically remove duplicate rows from the data provided in a tabular form. For example, let us consider […] Read More

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