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

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 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

How to hide row and column headers in Excel

Excel Worksheet by default displays the rows and columns header. For some reason if you want to hide these headers then you can use Excel Advanced Options. Listed below the steps to hide or unhide row and column headers in Excel 2016, Excel 2010 and Excel 2010.Step 1: Click the File menu and then options […] Read More

How to display results inside shapes in Excel

Here are the steps required for displaying any calculation result or cell value inside shapes in Excel 2016, 2013 and 2010. Let us see this with an example that displays the max of marks obtained in a shape.Step 1: Create the required Data set.Step 2: Select the cell to calculate the Max of marks, in […] Read More

How to check version of Excel

In Excel 2016, 2013 and 2010, the version of excel can be checked using the Help or Account menu.Click the File menu and select Help menu.Navigate to the About Microsoft Excel section displayed on the right hand side. This would display the Excel Version details, as shown below.Screenshot in Excel 2013And if you want to […] Read More

Rename a worksheet in Excel

In this short beginners tutorial, let us see the different ways to rename an worksheet in Excel 2016, 2013 and Excel 2010.The easiest option to rename a sheet is to simply double click the Sheet tab and rename it.  […] Read More

Print end date of previous month in Excel

In Microsoft Excel, if you want to find out the end date of previous month for the given current date then you can use TODAY() or EOMONTH().TODAY() – Returns the current date formatted as a date.EOMONTH() – Returns the number of the last day of month before or after the specified number of month.For example […] Read More

How to turn off printing cell errors in Excel

In the previous post, we had seen how to print cell comments in Excel and in this tutorial we will be seeing the steps required to turn of the cell errors displayed while printing a Worksheet in Excel 2016, 2013 and 2010.A worksheet displays different cell errors, for example when you have an invalid expression […] Read More

How to quickly find the sum of selected range in Excel

Even beginners to Microsoft Excel will be aware of sum function used for calculating the total for set of numbers. But if you want to quickly find out the sum of selected ranges then you can use the option available as part of Excel Status bar.For example, if you have got the above set of […] Read More

How to enable auto filter for protected sheet in Excel

We had already seen the following tutorials related with protection of worksheet in Excel 2016, 2013 & 2010. Prevent users from adding new worksheet. Password Protect Worksheet in Excel. Unprotect Worksheet in Excel. And if a worksheet with auto filter is protected then users will not be able to use auto filter unless it is […] Read More

Quickly delete blank rows in Excel

This tutorial explains the steps required for quickly deleting blank rows in Excel 2016, 2013 & 2010. For example, if you have analyzed some data and replaced the not required data with blank spaces. Now if you want quickly remove these blank rows then you can use option available as part of Go To feature.To […] Read More

How to preserve leading zero in Excel

Microsoft Excel 2016, 2013 and 2010 allows users to preserve the leading zero by defining a custom format. For example if you are entering a value in excel cell as 08500 and you haven’t specified any custom format then this value would appear as 8500. To preserve the leading zero, right click on the cell […] Read More

1 2 5

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