Viewing: Excel 2016

Print selected rows and columns in Excel

If you have a requirement where you want to print only certain rows and columns in a spread sheet then you can use print selection or set print area features in Excel 2016 and Excel 2013.The second method that we are going to see is by using the Print Area option available as part of […] Read More

What is Quick Analysis in Excel

Excel 2016 and 2013 provides users with popular tools for doing quick analysis of the selected data. The tools that are available as part of Quick Analysis are Formatting, Charts, Totals, Tables and Sparklines.Let us take the following sample data and have a quick look at the charts that can be for this data.Select the […] 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

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

1 2 3

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