Viewing: Excel 2016

How to insert spreadsheet in Word

We had earlier seen about performing simple math calculation in Word. And in this tutorial we are going to see the steps for adding spreadsheet in a word document. Let us see this by creating an invoice for the purchased items using Word 2016 and Word 2013. Insert Excel spreadsheet in Word 2013 Click the […] Read More

How to print only specific columns in Excel

This is going to be a short tutorial on printing only specific columns in Excel 2016 & 2013. Earlier we had covered the steps required for printing selected columns and this going to be in addition to that. For this demo, let us take the following sample data.   Now if you want to print […] Read More

How to prefix cell entry with zero in Excel

This tutorial is about the steps required to prefix cell entry with zero in excel 2016 & 2013. If you enter a number with leading zero, excel would automatically remove the zero. In the above sample data, though the phone number was entered as 09238292267, the leading zero has been removed by excel. You can […] 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

Advanced Features found in Excel 2016 & 2013 Which Users Ignore

One thing that is conspicuous about Excel 2016 & 2013 is the new look it exhibits. Although it does not have numerous new features, all the old ones have been improved such that they offer quick, professional and perfect results. Both old and new users are sure to enjoy the way these features help in […] Read More

How to display blank for zero value in Excel 2016 & 2013

Excel 2013 allows user to display blank value instead of zero value for any expression. This is useful when you want the result value for any formula to be left blank instead of displaying zero.Step 1: Click File menu, select Options from the menu list.Step 2: In the Options window, click the Advanced tab.Step 3: […] Read More

Group people based on the month in Excel 2016 & 2013

This tutorial explains the procedure for grouping people based on month from the given date field in Excel 2013. Let us take the following sample data with students name and their date of birth.Now to find out the list of students celebrating the birthdate grouped by months you can do the followingStep 1: Add another […] Read More

How to insert YouTube videos in Excel 2016 & 2013

In this tutorial, we are going to see the steps required for inserting YouTube videos in excel worksheet. Let us say you have created a Pivot Chart in Excel 2016 & 2013 and want to share it with users who are not familiar about Pivot Chart. Then you can embed some introductory YouTube videos about […] 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

Where is the location of custom templates folder in Office?

The custom templates created by using any Office 2016 and 2013 templates are stored under the following directoryC:\Users\<username>\Documents\Custom Office TemplatesThis location is different from the previous Office version, which was storing it underC:\Users\<username>\AppData\Roaming\Microsoft\TemplatesOffice 2013 allows you to change the default custom template folder location using the Setting available as part of the Office Options.Let us […] 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

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